| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIF Formula
I need to sum a column based on two different variables. For example I need
to sum Column A if Column B = 123 and Column C = XD. For the example below the sumif formula would equal "11." I have tried creating this formula several times but I have yet to succeed as I have always gotten some type of error. I could use the dsum formula but I would like to stick to"if" formulas. Any suggestions? Col. A Col. B Col.C 1 123 XD 5 222 XD 10 123 CC 10 123 XD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF formula | Excel Worksheet Functions | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Formula for If - SUMIF | Excel Discussion (Misc queries) | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
