sumproduct partial text count

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 -

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


"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 -
>
>

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

"Ron Coderre" wrote:

> 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
>
>
> "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 -
> >
> >