Hi,
I'm doing a sumif based off the data selected in a drop down list but I need a 'select all' option. So I need there to be an 'all' option in the drop down list which adds all the data in the list. Any help would be greatly appreciated guys. I've added an Excel sheet that further explains the problem.
Thanks
Maybe
=IF(K4="all",SUM(C:C),SUMIF(B:B,K4:K4,C:C))
Hi Azumi,
Thanks for you help. I did think of that but once this gets applied to my actual Spreadsheet, things would get quite messy with this method. I was hoping that there would maybe be a cleaner, more 'official' solution to this? Surely Excel has a built in method of dealing with something like this? It strikes me as something that would be needed quite often.
It can't get much simpler than what azumi gave you. You don't need K4:K4 in the formula.
Formula:
Please Login or Register to view this content.
What is it that could get messy?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks