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

=SUMPRODUCT((--(RIGHT($A$1:$A$1500,18)="Sales - to be Done"), ....

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

You are welcome ...

Thanks for the feedback