Forum Discussion
israabbasi
Jul 01, 2019Copper Contributor
Summation furmule with conditions
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
1 Reply
- SergeiBaklanDiamond Contributor
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))