| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to count based on different criteria in two columns
Hello. I am trying to count the number of Items in Col A that have
[videorecording] and a value of greater than 0 in Col E. For example: Col A Col E Broadway! [videorecording] 1 What I have so far is: =COUNTA(IF((A2:A203="*videorecording*")*(E2:E2030 ),A2:A203)) I get a return of 1, which I know is wrong. Just doing a quick glance, I see 5. Any help is appreciated. Thanks. adlin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text cells based on two criteria | Excel Worksheet Functions | |||
| Count distinct based on criteria | Excel Worksheet Functions | |||
| count cells,containing text, based on more than one criteria? | Excel Worksheet Functions | |||
| Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Threaded Mode
