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
Formula: copy to clipboard
=SUMPRODUCT(--(A1:A5>0), --(B1:B5="text"))


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!