Data Validation w/ Sum in Excel

Closed
EthosAri
Posts
1
Registration date
Sunday April 21, 2013
Status
Member
Last seen
April 21, 2013
- Apr 21, 2013 at 02:18 PM
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
- Apr 23, 2013 at 12:16 AM
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

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Apr 22, 2013 at 12:06 PM
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
0
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Apr 23, 2013 at 12:16 AM
@Ethos

HI

Please Try to upload a sample file with your requirement

Thanks

Patnaik
0