View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adlin Adlin is offline
external usenet poster
 
Posts: 2
Default 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