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

=SUMPRODUCT((LEFT(C33:C453,1)="A")*(G33:G4530))

Does that help?

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

XL2002, WinXP-Pro


"Ribeye" wrote:

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 -