Help with Excel
Hi Folks, I am looking for assistance with an Excel calculation issue - I have created a data validation list of 3 items (Lets say Monday, Tuesday and Wednesday.
Below, I have 3 lines Mar, April May and in the columns I have entered Day 1, Day 2 Day 3 and so on.
Now I need to enter a formula that calculates the the amounts based on the data in the data validation cell, that's the easy part, but how can I do this based on all items in the data validation cell using "all".
I hope we have an excel expert whom can help with this little issue.
I know I can Pivot instead of Data Validation, but I have my reasons I do not want to do this.
Many thanks in advance for your help
Paul
Deputy Manager - Credit Control, Receivables & Commercial
4 å¹´Hi.. share ur sheet, if i can help u out.
Assistant Manager at PHOENIX CONTACT (I) Pvt. Ltd.
4 年If u dont want to use pivot then use “consolidate data†formula
Production Lead I Exide Group I Ex- Kolors India I Assistant Production Manager | Ex-C&S Electric | Ex-Mahindra Group I Ex-Navyug
4 å¹´Pls share your excel sheet on en.ashishsinha@gmail.com and I'll give you the best possible solution.
Opinions expressed are mine.
4 å¹´Can you share a screenshot of your sheet? Countif and sumif can be used.