Data Validation w/ Sum in Excel

[Closed]
Report
Posts
1
Registration date
Sunday April 21, 2013
Status
Member
Last seen
April 21, 2013
-
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
Hello All,

I just found out about the drop down menu (Data Validation) feature, but I have a question in regard to it.

I am trying to create a list of totals that will have a possible 8 categories to fit into, determined by the drop down menu. I would then like to have 8 separate subtotals that give me the sum of all the totals that fit into category 'A', category 'B', and so on. The original totals will be added to one of the eight subtotals, which one to be determined by the category selected in it's drop down menu.

The only solutions I can think of seem excessively long winded. Does anyone have any ideas or suggestions?

Thank you!

2 replies

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Ethos Ari,

I can't quite follow your story, but I think you are looking for a way to link the drop down lists.

When item A is selected from DDL the second DDL shows content connected to A.
When item B is selected from DDL the second DDL shows content connected to B.

If my assumption is incorrect then please explain again maybe with conjuction of an example.

Best regards,
Trowa
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
@Ethos

HI

Please Try to upload a sample file with your requirement

Thanks

Patnaik