combined formulas

A

adidani

New member
Joined
Jan 12, 2017
Messages
8
Reaction score
0
Points
0
Hello,

Does anyone have an idea how to create a formula to only sum up visible cells
So for example if you filter for Group 2, it will only return the total of group 2?

see attached file - tab various formulas....

thanks
Adi
 

Attachments

  • Junior Analyst Candidate Test Dec 2016.xlsx
    35.4 KB · Views: 8
EAsily Done with tables, this could also be done in a pivot table
 

Attachments

  • Junior Analyst Candidate Answer.xlsx
    37.8 KB · Views: 9
You must log in or register to reply here.
Back
Top