Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help calculating totals
Hello!
I am using Excel 2002. I have a spreadsheet that is about 300 rows long. Each row refers to a specific serial# of a copy machine. Column A defines what brand the copier is, and say Column B defines how many copies it made. Column B would be the "January" column, so then I would C,D,E. etc for the 12 months going across. I am looking for an easy way, so at the bottom of the spreadsheet, I can have a total for each of the months, for the # of copies that each of the different brands made. I am constantly adding and removing different serial#'s, so I'm not sure what the easiest way of doing this is. If anyone can help me out, I would really appreciate it! Please feel free to email me direct if you need me to send you a copy of the spreadsheet. Thank you! Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
YTD Totals | Excel Discussion (Misc queries) | |||
Highlighting(coloring) totals in a pivot table | Excel Worksheet Functions |