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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com