Forum Discussion
SUMIFS Horizontal for period between 2 dates
Is there a way to find the Sum of a row between 2 dates by column A (name)
I’ve tried a SUMIFS but since my data is in row and not column I cannot make it work.
Louise,
Sorry, I've updated the attached file with the right solution.
Please find it down below.
Got it. Thank you. I just added
=SUMPRODUCT((Data!$B$3:$M$3>=$B$1)*(Data!$B$3:$M$3<=$D$1)*(Data!$B4:$M4))--(Data!$A$4:$A$7=Result!$A4)
and it work. Thank you for all your help. I've never use SUMPRODUCT and you've help me greatly.