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

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

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

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