Thread: Count if
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Count if

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

"Adam" wrote:

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