I have attached a simple table which includes drop down options for columns C, D, E
I am hoping that the SUM line (47) can be designed to show only the totals for the items selected.
For example....if "Jaya" is selected for Column E...the Totals on Line 47 should just be for Jaya items. .... and likewise for any other selections.
I'm sure it is easy....I'm just a newbie....THANKS !Sample Marketing Report.xlsx
Put this in 47 (F47)
Then drag across to the other cells on 47
Please Login or Register to view this content.
Last edited by gmr4evr1; 03-27-2015 at 12:46 PM. Reason: Edit mistake in formula
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Yes...I understand that I can do that for "Jaya"....but what if I want the totals to change with each selection from the Column E drop down. If I put that formula in Line 47, it won't give me total for "Geetha" when her name is selected. And I don't want to have to manually change Line 47 formulas each time. Is there not a function to sum "only" the items listed after the drop down has been selected?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks