Summation furmule with conditions

Copper Contributor

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

@israabbasi 

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))