View Single Post
  #1   Report Post  
Lucien
 
Posts: n/a
Default CountIf formula help

I have a document with 2 worksheets. I need to count how many times item
12W45 occurs and how many times this item has a value of <=3 in another
column. Here is the formula that I am using, or trying to use:

=COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606))

Something is wrong because it is giving me a value of 1, when it should be
7.
Can anyone tell what I am doing wrong?