Previous Topic Next Topic

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

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
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
Answer 2 / 2
sgmpatnaik Posts 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 23, 2013 at 12:16 AM
@Ethos

HI

Please Try to upload a sample file with your requirement

Thanks

Patnaik
0