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

Multiple and flexible conditions

A

Ajinkya

Member
Hi,


first i would like to wish you good morning !!!


While day to day routine job, i again stucked in following query,


I have master sales data in this locations, item and date wise sales is available


but a want ONLY for selected location, selected item and selected dates ( two range) wise SUM for the sold items


excel file is uploaded ,link as per following


Download link:

https://hotfile.com/dl/156586908/cb09ede/Multiple_and_flexible_conditions_V1.xlsx.html


in this Criteria dates are flexible (highlighted in blue)

Where location and items are also not fixed (highlighted in blue)

and in this i want formula in highlighted yellow cells for the summetion of the sold items with multiple criterias location and item wise how many items sold in the selected dates

e.g in Goa oil is sold 6,000 from the seleted date 03 may to 08 may.


in Pune cement is sold 12,000 from the seleted date 03 may to 08 may.


Please remember, here location items dates are not fixed,these are flexible.


Thanks in advance !!!
 
Hi Ajinkya,


Enter this one in D13 and drag down:


Code: 
=SUMPRODUCT(($B$5:$B$7=$B13)*($C$5:$C$7=$C13)*(D$4:AL$4>=$D$10)*(D$4:AL$4<=$E$10)*$D$5:$AL$7)


Regards,

Faseeh
 
Its done, g8 for me, thanks a lot dear,

ofcourse we can be a friend, could you text me on ajinkya.bhavsar@yahoo.com
 
You must log in or register to reply here.
Back
Top