Counting only the "right" activities

[Kreller]

Thanx. The sumproduct formula works fine - I haven't really dissected i
yet so i'm not sure I understand why it works - but it does, and that'
what's important :

 

[Alex Delamain]

Sumproduct is not quite the answer to life, the universe and everythin
......but it is very useful for pulling data out of large tables.

see below for more info on how it works

http://www.contextures.com/xlFunctions01.html#SumProduc

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
discussion on using SUMPRODUCT for Multiple conditional tests