Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF Question
This may or may not be possible...... But I would like to be able to sum up
the numbers from one column only if they are For example A B Expense Code Budgeted Amt. 111 $100 112 $200 111 $300 I would like a formula that add up only the dollar amounts for items whose "Expense Code" is 111....... There are forty line items with various expense codes and I need to be able to total everything as well as break it down by expense code for a separate table. I can't designate certain cells to be included because they are constantly changing or are different for each case (110 sheets represent 110 different entities) so the formula must have the criteria from one cell (Expense Code) to filter outthe dollar amounts. Is this even possible? Any and all help will be greatly appreciated Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
this may be simple, sumif question | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
sumif Question | Excel Discussion (Misc queries) | |||
SUMIF question | Excel Worksheet Functions |