Jun 30 2019 10:58 PM - edited Jun 30 2019 11:51 PM
Dear All,
I need your support to have formula summing the data between months with Horizontal and vertical conditions as explained in the attached file.
Thanks a lot in advance.
Best Regards,
Isra
Jul 01 2019 01:30 AM
That could be like
=SUMPRODUCT(Data!$D$5:$O$22*(Data!$D$4:$O$4>=$B$3)*(Data!$D$4:$O$4<=$B$4)*(Data!$C$5:$C$22=$B$2))