SumIF Exact

[DDH]

I have a column (AI) of dates and a column (AJ) with the day of the week, and
a column (AM) with numbers in it.
I found that where I had the "0" for the exact was not working.
It was one day behind.
It put "Sat" numbers in "Fri" and "Sun" in "Sat".

Thank you for your help.

SUM(SUMIFS($AM$2:$AM$533,$AM$2:$AM$533,{"<0",">0"},$AJ$3:$AJ$534,AB48),0)

 

[DDH]

I figured out what I was doing wrong.

SUM(SUMIFS($AM$2:$AM$533,$AM$2:$AM$533,{"<0",">0"},$AJ$2:$AJ$533,AB48),0)

Thank you.