SUMIFS + AND Formula

[JADownie]

Hello -

I have the following SUMIFS formula that I am trying to incorporate an AND statement.

My current formula is:

=SUMIFS(B27:B1000,X27:X1000,"Active",X27:X1000,"Transfer")

I am trying to add an AND statment into this formula which would say AND IF AR ≠ blank, do not include the value from row B in the sum.

Is that even possible, or is this way too complicated now?

 

[grd]

Whilst I've used SUMIF plenty of times in the past I've not used SUMIFS before so not sure if there is something extra other than just adding two or more criteria.

However, is it not possible to achieve what you want by having a separate value column which is filtered with your IF AR ≠ blank thereby removing value in row (column?) B?