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!
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!
try this formula
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Another way. Enter in K4 and copy across.
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
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?
I leveraged newdovermans SUMPRODUCT formula..
Please Login or Register to view this content.
Thanks newdoverman
My 1st question would be - why on earth would you have more than 1 column for the same date's info??
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There seems to be something more to this problem than stated.
Thank you judgeh59!
no problem....glad I could help....and thanks to newdoverman for the SUMPRODUCT function...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks