CountIf

[LisaP]

I have two columns - named "type" and "gender" (as an example). I want to count how many dogs (under type) are male (under gender). No problem just to find out how many dogs ie: =countif(type,"dogs") but can figure out the formula on how to use criteria from both columns.

Anyone have any suggestions?

[VBA Noob]

Try Sumproduct

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob

[LisaP]

Yes that worked - I used both the sum array and sum product effectively. Only problem is it doesn't seem to like using the name as the range.

Thanks!

[NBVC]

Yes that worked - I used both the sum array and sum product effectively. Only problem is it doesn't seem to like using the name as the range.

Sumproduct() does not allow full column referencing, i.e. A:A cannot be used, so if your named range is the full column, then it won't work in Sumproduct()... you can redefine your range to a defined range, e.g A1:A1000... (you can't use A1:A65536 either....you can use A2:A65536 or A1:A65535)....