Forum Discussion
Solved
SUMIFS with Criteria on Horizontal and Vertical Axis
Hi, Please I need assistance with SUMIFS function to get values between two dates which are on horizontal axis and a third criteria which is on the vertical axis. As shown in the attached ima...
OlawaleSheks Try SUMPRODUCT instead. In cell F3:
=SUMPRODUCT(($I$2:$N$2>=D3)*($I$2:$N$2<=E3)*($H$3:$H$14=C3)*$I$3:$N$14)Copy down as needed.
Instead of SUMIFS, use SUMPRODUCT (if you have Microsoft 365 or Office 2021, SUM will work as well).
=SUMPRODUCT(($H$3:$H$14=C3)*($I$2:$N$2>=D3)*($I$2:$N$2<=E3)*$I$3:$N$14)
- Thanks a lot HansVogelaar
