Thread
:
Sum Count of Criteria Every 3rd Row
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur
Posts: n/a
Sum Count of Criteria Every 3rd Row
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
Reply With Quote