• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIF based on varying input

I

Ilyas1979

New Member
Hi all,

I am working on a file for calculating material requirement on monthly basis for a project. In sheet5 of the attached file I want to calculate the total material from start of project till date in columnE (i.e. Cumu. consumption till date). I want a formula that could calculate the quantity of material (say cement) from start of project say January till date. I have entered the required results.

Thanks & Regards,
Ilyas
 

Attachments

Hi Ilyas,

If you column E on sheet5 is required answer than see this file, column I (orange colour). I had consider only 25 rows of data in the formula, and made the change in your sheet 4 formula where you are getting monthly values and replaced "" by 0 in that formula.

Regards,
 

Attachments

Thanks a lot Somendra Sir. Is it possible to calculate quantities based on entries between 2 months. Say from Mar 15 to Aug 15.

Regards,
Ilyas
 
Hey Got the result: In J3 I entered the date say 1/4/15 and K3 i entered 1/7/15 and in K4 i used the formula:
=SUMPRODUCT(((Sheet4!$H$1:$AE$1<=K$3)-
(Sheet4!$H$1:$AE$1<J$3))*Sheet4!$H$2:$AE$25*(B4=Sheet4!$F$2:$F$25))

and got the desired result. Thanks again Somendra Sir without your help this wasn't possible. All the excel ninjas and even the active members of this forum are awesum. Salutes to you all.

Regards,
Ilyas
 
You must log in or register to reply here.
Back
Top