Forum Discussion

Copper Contributor

Mar 03, 2018

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.

Formulas & Functions

tips and tricks

Louise Bedard

Copper Contributor

Mar 03, 2018

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

Example.xlsx14 KB

Haytham Amairah

Silver Contributor

Mar 03, 2018

Louise,

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

Please find it down below.

Example (Updated).xlsx15 KB

Louise Bedard
Copper Contributor
Mar 03, 2018
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.
Louise Bedard
Copper Contributor
Mar 03, 2018
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.