| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate?
Hi - how do I calculate a value from one column where the value in another
column contains a certain customer name? For example: I want to know from my spreadsheet how much $$ that customer "BabyChime" has paid for 2006. So I want a formula that will look for each customer and the matching dollars. My customer names are in column D and my dollars are in column J. Does this make sense? I was using this but it's not working. =SUM(--(completed!D2:D181="BabyChime"),--(completed!J2:J181="*")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't get excel to calculate | Excel Worksheet Functions | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| how to calculate a cube root | New Users to Excel | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Threaded Mode
