Subtract value over multiple cells

[Blake0920]

Trying to figure out a formula where I can subtract a value from a series of cells.

This is what I have now but it is not putting that value in any of the cells. =SUM(((Y12:Y18*(AD5:AD5="8")*(AA5:AA5>="02-01-2022")*(AA5:AA5<="02-31-2022"))))-AE5

 

[Blake0920]

It is very weird, anytime I copy that whether it is yours or mine in a new sheet or new book I automatically get the #VALUE!

I really dont get it

 

[jtakw]

I notice you're working on a XLSM file (macro enabled), do you have any macros running in the background that may be causing this problem?
Another question, just to be sure, your profile says you're on Excel 2016, is that indeed what you're using?