JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
Can someone please explain to me why the results in Col I are negative? The absolute values are correct, but the signs are wrong.
Oh for Pete's sake. The Alzheimer's is a lot worse than I thought. ? I spent all my time looking inside then expression and completely missed that. Thank you.You have a - sign between = and SUMIFS which is going to invert the final result of the formula.
Thanks. I'm totally embarrassed.Jennifer there is a negative sign right in front of the SUMIFS. That negative sign is turning all your numbers negative.