| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for multiple cells if they say a certain thing
I am looking for a formula where one cell will equal the total of mutiple
cells IF the cells say a different thing. Example: Column A has the Description "PUR" or "SK" Column B has the Description "HY" or "CBN" Column C has the total of that row (manually entered) I want the total amount from col C to be all of the "PUR" or "SK" of "HY" or "CBN" So it would be IF cell A has PUR and cell B has HY then the amount in column C for those will be totaled here. And so on as there could be 4 different ways since it could be "PUR" of "HY", "PUR" of "CBN" or "SK" of "HY", "SK" of "CBN". Does this make any sense? It is hard to explain. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple formual'a that equal the same thing | Excel Worksheet Functions | |||
| do the same thing to multiple hard coded cells | Excel Worksheet Functions | |||
| Changing the Same thing on multiple charts | Charts and Charting in Excel | |||
| get pivot data formula - is it the thing to do | Excel Worksheet Functions | |||
| The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
Threaded Mode
