| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a formula
I would like to create a formula in one cell that would calculate amounts in
a given range. For example: Column A Column B Apples $10 Oranges $20 Bananas $15 Apples $10 Pears $50 Apples $10 From the chart above, I can see that the amount spent on Apples was $30. I would like to create a formula that would lookup Apples in column A and total the corresponding amount from column B (without having to sort column A). Any help is greatly appreciated. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a formula that exceeds 1,000 characters | Excel Worksheet Functions | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
Threaded Mode
