Hi,

Try the following array formula (Ctrl+Shift+Enter). Assume your data is in
range A13:A17

23
34
56
45
34

In A19, enter the following array formula (Ctrl+Shift+Enter)

=SUM(IF((MOD(ROW(A13:A17),2)=0*(A13:A174)),$A$13: $A$17,0))

The result of this will be 79.

If you have any problems please feel freet o contact me at


Regards,


"Sam via OfficeKB.com" 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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1