excelisagony
New Member
- Joined
- Sep 23, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I'm at my wits end.
The following formula works perfectly:
=SUMPRODUCT((SUMIFS(E:E,C:C,DEVELOPMENT,B:B,"1660-Company")))
However, if I add a second named range it gives me an incorrect value:
=SUMPRODUCT((SUMIFS(E:E,C:C,DEVELOPMENT, D:D, TOTALEMPCOMP, B:B,"1660-Company")))
Any thoughts on what I am doing incorrectly?
Thank you, Excel Experts!
The following formula works perfectly:
=SUMPRODUCT((SUMIFS(E:E,C:C,DEVELOPMENT,B:B,"1660-Company")))
However, if I add a second named range it gives me an incorrect value:
=SUMPRODUCT((SUMIFS(E:E,C:C,DEVELOPMENT, D:D, TOTALEMPCOMP, B:B,"1660-Company")))
Any thoughts on what I am doing incorrectly?
Thank you, Excel Experts!