SUM (not sumproduct) with 2 criteria

I am trying to sum accross a range of data and text with 2 criteria. I cannot use sumproduct (to the best of my knowledge) due to the text. The equation I am trying is

=SUM(IF(AND(RIGHT($A$1:$A$1500,18)="Sales - to be Done",ROW($A$1:$A$1500)>100)=TRUE,$B$1:$B$1500))

but this is resulting in zero

Note there is text in column B in the range of rows

Any suggestions? Or does SUM(IF(AND(
just not work?

Hi Duane,

You can use sumproduct with text as long as you add double unary operator ...

Please Login or Register  to view this content.

thank you very much - never used the double unary before - always the *

You are welcome ...

Thanks for the feedback