| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to count based on different criteria in two columns
=SUMPRODUCT(--(ISNUMBER(FIND("videorecording",A2:A203))),--(E2:E2030))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Adlin" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to count based on different criteria in two columns
It worked! Thanks so much!
Adlin "Bob Phillips" wrote: =SUMPRODUCT(--(ISNUMBER(FIND("videorecording",A2:A203))),--(E2:E2030)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Adlin" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to count based on different criteria in two columns
try sumproduct
=SUMPRODUCT((A2:A100="videorecording")*(E2:E1000) ) Mike "Adlin" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
