Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMULA
I have a table with a cell for budget code and a cell for total cost. I want
a total at the end of the table for each budget code so that I can cost it out properly without manually adding each entry for each code. For example: BUDGET CODE 5160 TOTAL CHARGES $2.00 BUDGET CODE 5131 TOTAL CHARGES $3.50 BUDGET CODE 5160 TOTAL CHARGES $3.50 Then at the end of the table I want to total each budget code: BUDGET CODE 5160 TOTAL $3.50 ETC. Currently I use the calculator and manually add 30 or 40 entries scattered throughout the table, sometimes missing an entry etc. and want to set up the spreadsheet to do this. -- Thanks, Pat |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMULA
Ok, let's assume that your buget codes are in column B and your charges are
in column D. =sumif(b:b,"=5160",d:d) Repeat for each Budget Code Or, if you have other data on your worksheet in those columns that you don't want added in, you can specify a specific range (like rows 2 thru 50): =sumif(b2:b50,"=5160",d2:d50) HTH, Elkar "Pat" wrote: I have a table with a cell for budget code and a cell for total cost. I want a total at the end of the table for each budget code so that I can cost it out properly without manually adding each entry for each code. For example: BUDGET CODE 5160 TOTAL CHARGES $2.00 BUDGET CODE 5131 TOTAL CHARGES $3.50 BUDGET CODE 5160 TOTAL CHARGES $3.50 Then at the end of the table I want to total each budget code: BUDGET CODE 5160 TOTAL $3.50 ETC. Currently I use the calculator and manually add 30 or 40 entries scattered throughout the table, sometimes missing an entry etc. and want to set up the spreadsheet to do this. -- Thanks, Pat |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMULA
Assuming the Budget Codes are in col B and the $$ are in col D, use
=SUMPRODUCT(--(B1:B500=5160),D1:D500) "Pat" wrote: Sorry to confuse I meant the end of the table total should be $5.50 as it is adding all entries for 5160 code. -- Thanks, Pat "Pat" wrote: I have a table with a cell for budget code and a cell for total cost. I want a total at the end of the table for each budget code so that I can cost it out properly without manually adding each entry for each code. For example: BUDGET CODE 5160 TOTAL CHARGES $2.00 BUDGET CODE 5131 TOTAL CHARGES $3.50 BUDGET CODE 5160 TOTAL CHARGES $3.50 Then at the end of the table I want to total each budget code: BUDGET CODE 5160 TOTAL $3.50 ETC. Currently I use the calculator and manually add 30 or 40 entries scattered throughout the table, sometimes missing an entry etc. and want to set up the spreadsheet to do this. -- Thanks, Pat |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMULA
Thank you very much your formulas worked great. What a life saver!!!!
-- Thanks, Pat "Pat" wrote: I have a table with a cell for budget code and a cell for total cost. I want a total at the end of the table for each budget code so that I can cost it out properly without manually adding each entry for each code. For example: BUDGET CODE 5160 TOTAL CHARGES $2.00 BUDGET CODE 5131 TOTAL CHARGES $3.50 BUDGET CODE 5160 TOTAL CHARGES $3.50 Then at the end of the table I want to total each budget code: BUDGET CODE 5160 TOTAL $3.50 ETC. Currently I use the calculator and manually add 30 or 40 entries scattered throughout the table, sometimes missing an entry etc. and want to set up the spreadsheet to do this. -- Thanks, Pat |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL FORMULA
Sorry to confuse I meant the end of the table total should be $5.50 as it is
adding all entries for 5160 code. -- Thanks, Pat "Pat" wrote: I have a table with a cell for budget code and a cell for total cost. I want a total at the end of the table for each budget code so that I can cost it out properly without manually adding each entry for each code. For example: BUDGET CODE 5160 TOTAL CHARGES $2.00 BUDGET CODE 5131 TOTAL CHARGES $3.50 BUDGET CODE 5160 TOTAL CHARGES $3.50 Then at the end of the table I want to total each budget code: BUDGET CODE 5160 TOTAL $3.50 ETC. Currently I use the calculator and manually add 30 or 40 entries scattered throughout the table, sometimes missing an entry etc. and want to set up the spreadsheet to do this. -- Thanks, Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |