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
|