Sum total by cell type

[amorshc]

Help! I've searched and searched and I can't seem to make my formula work the way I need it to.

I have 2 cells.
A contains a total # (IE, 1,2,3,4)
B contains a cell with text that is static (Does not change)
C - where my formula is summing at

The formula i'm using is

Please Login or Register  to view this content.

This works great... with one problem. If A1 has 1, and A2 has 2, the formula only see's a sum of 2 (Not 3).

I know its probably simple, but i've tried and tried.

PLEASE HELP!

Thank you!

[berlan]

Change,

=SUMPRODUCT(--(A1:A5>0), --(B1:B5="text"))

to

=SUMPRODUCT(A1:A5, --(B1:B5="text"))

since if you add >0 it will convert to True (=1) or False (=0) which is why you get a sum of 2.

Or try,

=SUMIF(B1:B5,"text",A1:A5)

Hope that helps

[Glenn Kennedy]

... or

=SUMIF(B:B,"text",A:A)

[amorshc]

Thanks! Both of these worked, and I knew it was something small. Thank you again! Rep+ for both of you.

[Glenn Kennedy]

Cheers... and you're welcome.