SUMIFS Horizontal for period between 2 dates

[Louise Bedard]

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.

[#2]

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)

[#3]

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".  

[#4]

Louise,

Sorry, I've updated the attached file with the right solution.

Please find it down below.

[#5]

Thank you, but that work if the order of the name on both sheet are in the same order but in my case they are not in the same order and since it is multi rows split in Different Business Unit so the order cannot change. Normally I would have done a SUMIFS with criteria Name but that doesn't work with row data.

[#6]

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.