Sum Count of Criteria Every 3rd Row
Assuming that A1:A100 contains your data, to count every third row,
starting with the first cell in the range, try...
=SUMPRODUCT(--(MOD(ROW(A1:A100)-ROW(A1)+0,3)=0),--(A1:A100=B1))
....where B1 contains your criteria. To count every third row, starting
with the third cell in the range or the first occurrence of third,
change the +0 bit to +1.
Hope this helps!
In article <5898fe5a1a483@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:
Hi All,
I would like to Sum the Count of numerical values in Every 3rd Row BUT ONLY
IF the value(s) equals a specific criteria.
Example:
Sum Count of Every 3rd Row that has a value of 50. The criteria will vary.
Cheers,
Sam
|