Drop Down List - Showing all

good afternoon all,

I've created a drop down list that summarizes data based on a criteria. I know how to specify a value but not sure how to include an option to show all values. First time attempting this, any advice would be great.

 Please refer to attachment.

Formula
=SUMPRODUCT(--($A6=Data!$C$2:$C$41),--($B$3=Data!$B$2:$B$41))
Drop-Down-Example.xlsx
jbakestullAsked:
Who is Participating?
 
FlysterCommented:
Try this in B6:

=IF(B3="All",SUMPRODUCT(--($A6=Data!$C$2:$C$41)),SUMPRODUCT(--($A6=Data!$C$2:$C$41),--($B$3=Data!$B$2:$B$41)))

Flyster
0
 
jbakestullAuthor Commented:
I never even thought of using an if statement.. I feel embarrassed.

thanks formula worked great.  
0
 
jbakestullAuthor Commented:
thanks,,
0
 
FlysterCommented:
I'm glad I could help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.