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.
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.
djclements, this works. Thanks very much for your help!