ExcelBanter - sumproduct partial text count

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumproduct partial text count (https://www.excelbanter.com/excel-worksheet-functions/71588-sumproduct-partial-text-count.html)

Ribeye

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 -

Ron Coderre

sumproduct partial text count

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 -

Ribeye

sumproduct partial text count

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

"Ron Coderre" wrote:

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 -

All times are GMT +1. The time now is 08:52 PM.