Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Is there a better Formula rather than i used here in this Sheet?

0

Hi friends,

attached herewith the excel data sheet where i wish to arrive the answer with different variables.

is there any simpler way to arrive to the formula just with a single click?

Also attached 2nd sheet, test upd to know more on pivot table 

advance thanks for your help

excel
MS Office Version: 2010
posted by: Sattya on Fri May 17, 2019 at 11:09 pm
Answer
Discuss

Discussion

For the Second File 'Test - upd'   Please change validation value of N19 from 'Auarter III' to 'Quarter III'.        Now insert this formula in D20, =SUMPRODUCT((C5:C14=D15)*("Q "&MID(D16,FIND(" ",D16)+1,5)=D2:AI2)*(D17=D3:AI3)*(D4:AI4=IF(D18="Sales","Sale",IF(D18="Enquiry","Enq")))*(D5:AI14))
ANAND KUMAR (rep: 35) May 18, '19 at 3:54 am
Anand, if this is an Answer, don't forget to put it in the Answer section so you can get credit for it :)
don (rep: 1989) May 19, '19 at 1:12 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login