| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the times a value appears in a column based on another value
I am using the following formula to count the number of times "Web" appears
in column B based on "1" being in column D: =IF('List of Reviews'!B:B="Web",COUNTIF('List of Reviews'!D:D,1),0) I continue to get a #NUM! error for the logical test in the IF statement even when the formula is reversed and I try to count the number of times "Web" appears for every row which contains a "1" in column D. What is wrong with the formula? Is there another function that will return the correct result? Just a note: The COUNTIF function works each time to find the right value for the criteria entered. Help needed quickly! Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many times the same word appears in column | Excel Discussion (Misc queries) | |||
| Count the number of times specific text appears in a column | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| How do I count how many times a code appears in a column? | Excel Worksheet Functions | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Threaded Mode
