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.
Hi Louise,
I've attached the solution for you.
It's done by using this array formula:
=SUMPRODUCT((MONTH($B$1:$M$1)>=$C$7)*(MONTH($B$1:$M$1)<=$D$7)*$B2:$M2)
Thank you for your response. Sorry I think I didn't explain properly. This is my first time using this forum. I have attached an example of what I want. My problem is that I need the result to return to another sheet, so I have a criteria "Name".
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.
