Linking drop down menus to calculations

Hello,

I'm brand new to the site so hello to all,

I have the following query. I'll try to explain it as best that I can.

Imagine a simple excel file. In column "A" there is a drop down menu for each line (for eg the options are "Sales" and "Expenditure")

Column "B" has NO drop down and I simply enter numerical values as required.

So imagine line 2 I select "Sales" in column A and enter a value of $200.00 in column B

Then in line 3 I select "Expenditure" in column A and enter a value of $300.00 in column B

And so on for maybe 30 or 40 lines or more alternating between options "sales" and "expenditures" and entering various $ values.

Now, here comes the query. Imagine, in another worksheet, that I wanted to calculate the $ value for either "sales" or "expenditure". How could I do that? I know I could easily just use a filter on column A to calculate the value but I need to generate a more substantial file than that.

I hope my above explanation is coherent. If not please let me know and I'll try explain myself a bit better. Also I hope I am in the correct forum section??? Perhaps I should be in the Macros section (until I know the answer unfortunately I don't really know what section I should be in).

Any information would be gratefully appreciated - even if someone could direct me to an online source of info on the topic I would be greatly appreciative.

Thanks in advance

Mark

Many thanks benishiryo,

Really appreciate it. Will try that now.

Many thanks

Mark