MOD ROW REFERENCING CRITERIA

[ozbeachbum]

Hi all,
I am endeavouring to sum every nth row where it matches a criteria in another column.
I have tried the following formula with the result #N/A.
=SUMPRODUCT((MOD(ROW(D3:D19)-3,3)=0)*(C2:C19="CBD"),(D3:D19))
I was hoping that it would sum the amount in every THIRD row in column D where it matched the criteria in column C "CBD"
Attach worksheet example.
Any assistance would be greatly appreciated.
Cheers,
Dave.

mod row criteria.xlsx
	G
10
Sheet1

 

[JEC]

You need the same range, everywhere in your formula (so close!)

=SUMPRODUCT((MOD(ROW(D3:D19)-3,3)=0)*(C3:C19="CBD"),(D3:D19))

 

[ozbeachbum]

Hi Jec,
Thanks for the suggestion, however it returns ZERO.
Any thoughts?

 

[ozbeachbum]

Hi Again,
Solved, I need the "CBD" to be in every 3rd row, where as I had it in the previous row to the $.
Thanks again, your reply prompted me to look further when it returned zero.
Cheers,
Dave.