Need to count based on different criteria in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:E203>0),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
 
=SUMPRODUCT(--(ISNUMBER(FIND("videorecording",A2:A203))),--(E2:E203>0))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
It worked! Thanks so much!

Adlin

Bob Phillips said:
=SUMPRODUCT(--(ISNUMBER(FIND("videorecording",A2:A203))),--(E2:E203>0))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Adlin said:
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:E203>0),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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count columns that meet criterias 3
Counting number of rows based on mutiple criteria 2
Search between dates & return other column 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Comparing the values in two cells, then counting how many differ 2
Multiple Criteria & Count if Equals 0 4
Count multiple criteria 7
Count Distinct Values based on criteria 4

Back
Top