SUMIFS Horizontal for period between 2 dates

Question

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 bedard · Answer

Got it.&nbsp; Thank you.&nbsp; I just added&nbsp;
&nbsp;
=SUMPRODUCT((Data!$B$3:$M$3&gt;=$B$1)*(Data!$B$3:$M$3&lt;=$D$1)*(Data!$B4:$M4))--(Data!$A$4:$A$7=Result!$A4)
&nbsp;
and it work. Thank you for all your help.&nbsp; I've never use SUMPRODUCT and you've help me greatly.

haytham amairah · Answer

Hi Louise,
&nbsp;
I've&nbsp;attached the solution for you.
It's done by using this array formula:
=SUMPRODUCT((MONTH($B$1:$M$1)&gt;=$C$7)*(MONTH($B$1:$M$1)&lt;=$D$7)*$B2:$M2)

louise bedard · Answer

Thank you for your response.&nbsp; Sorry I think I didn't explain properly.&nbsp; This is my first time using this forum.&nbsp; I have attached an example of what I want.&nbsp; My problem is that I need the result to return to another sheet, so I have a criteria "Name".&nbsp;&nbsp;

haytham amairah · Answer

Louise,
&nbsp;
Sorry, I've updated the attached file with the right solution.
Please find&nbsp;it down below.

louise bedard · Answer

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.

Forum Discussion

SUMIFS Horizontal for period between 2 dates

5 Replies

Resources