Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make a countif formula with 2 or more critera? | Excel Worksheet Functions | |||
countif formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
COUNTIF formula problems | Excel Discussion (Misc queries) | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |