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?