sumproduct partial text count

R

Ribeye

Trying to count # of times A occurs with another variable B. i.e.

A-1 1 Trying to find a way to count the # of
A's when they are
A-2 2 greater than 1. I've tried the following
but it doesn't work:
A-3 - =SUMPRODUCT((C33:C453="A*")*(G33:G453)>0))
A-4 - It seems like the * is throwing it
off......Help....Thanks
A-5 4
B-1 7
B-2 -
 
R

Ron Coderre

In this instance...perhaps this will work for you:

=SUMPRODUCT((LEFT(C33:C453,1)="A")*(G33:G453>0))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
R

Ribeye

Worked perfectly......Thanks a lot.

Ron Coderre said:
In this instance...perhaps this will work for you:

=SUMPRODUCT((LEFT(C33:C453,1)="A")*(G33:G453>0))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Top