Hi,
On the attached speadsheet I want users to be able to get an average by selecting a house using the drop down in cell E3. This works fine but I also want them to be able to select all the houses. But I cant get this to work. Any ideas on how to do this?
Enter formula in G3
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 05-04-2016 at 04:27 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
I can't help thinking you'd be better off with a Pivot Table - see attached. Use the drop down filter to hide items not required
And if you happen to have Excel 2010 or later when Slicers were added then they will offer an even better way of filtering the PT.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here's another one.
Array entered**:
=AVERAGE(IF(E3="All",B4:B12,IF(A4:A12=E3,B4:B12)))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
another solution.
with a pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks