Count if

[Adam]

Hey Guys, i Want to use COUNTIF function liek this..

(Range, Criteria, [count_range]

when you use count if, it will just let you do one if statement, (range,
criteria).

Basically i want to have it count one column based on a certain criteria, if
a another column meets a an additional criteria. Basically the way the SUMIF
command is set up.

Thanks,

-Adam

 

[Mike]

This should help
http://xldynamic.com/source/xld.SUMPRODUCT.html