View Single Post
Sawday

 
Sawday's Avatar
 
Member Since: Nov 19, 2006
Location: York, UK
Posts: 1,029
Sawday is a jewel in the roughSawday is a jewel in the roughSawday is a jewel in the rough
Mac Specs: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPhone4

Sawday is offline
Try this link Excel: Count If with Multiple Criteria. Excel Count with Multiple Criteria.

I do something very similar and though it took a bit of time to get it exactly right it now works for me though the logic in the formula seems counter intuitive. Read the whole page but I think the section that will solve your problem is 'SUM as an Array Formula'. The example there is a bit more complicated than you need but if you look what is happening you can simply it. One important point - having typed in the formula don't just press Enter but CTRL SHIFT ENTER.

Hope this helps.

Happiness is not getting what you want, but wanting what you get.
QUOTE Thanks