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

How to Pull Data from a Date Range Based on Criteria

Dear all,
I need to pull Cummulative Total from Daywise Sheet based on the Location code criteria and from a specific Date Range mentioned in F3 and G3 Cells.

File Attached.

Kindly help me on this.

Regards,
Deepak
 

Attachments

Hui

Excel Ninja
Staff member
E8: =SUMPRODUCT(('Daywise''2019'!E2:NE2<=$G$3)*('Daywise''2019'!E2:NE2>=$F$3)*('Daywise''2019'!$C$4:$C$55=$C8),'Daywise''2019'!$E$4:$NE$55)

then Copy down
Note that the ranges are of equal length/height now
 
Top