SUMIFS problem

**Villalobos** · 08-12-2014, 02:21 PM

Hello,

I would like to ask some help how to SUMIFS the "TOTAL DEMAND" week by week.
I have attached the sample file.

Thank you in advance the help!

**judgeh59** · 08-12-2014, 02:33 PM

try this formula

Please Login or Register  to view this content.

**newdoverman** · 08-12-2014, 03:19 PM

Another way. Enter in K4 and copy across.

Formula:

Please Login or Register  to view this content.

**Villalobos** · 08-12-2014, 03:27 PM

Thank you, your solutions are working fine.
I would have one more question, how to SUMIF there are same weeks columns next to each other?

**judgeh59** · 08-12-2014, 03:57 PM

I leveraged newdovermans SUMPRODUCT formula..

Please Login or Register  to view this content.

Thanks newdoverman

**FDibbins** · 08-12-2014, 04:07 PM

My 1st question would be - why on earth would you have more than 1 column for the same date's info??

**newdoverman** · 08-12-2014, 05:02 PM

There seems to be something more to this problem than stated.

**Villalobos** · 08-12-2014, 05:10 PM

Thank you judgeh59!

**judgeh59** · 08-12-2014, 05:12 PM

no problem....glad I could help....and thanks to newdoverman for the SUMPRODUCT function...

Re: SUMIFS problem