Hi Duane,
Thank you for reply. I've tried the solution below, but do not get the
expected answer. Not sure why?
=SUMPRODUCT((A1:A10=50)*(MOD(ROW(A1:A10)-1,3)=0)*(A1:A10))
Cheers,
Sam
duane wrote:
if I read your question right you want to sum the occurances of 50, but only
those in every 3rd row.
So, for the range of a1:a10, summing those 50's in rows 1,4,7,10
=SUMPRODUCT((A1:A10=50)*(MOD(ROW(A1:A10)-1,3)=0)*(A1:A10))
you could refer to cells with the values of 50 and 3 in the formula if
desired vs the hard coding of the values in the formula
Hi All,
[quoted text clipped - 6 lines]
Cheers,
Sam
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1