Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Reculations in Excell
How do I set up an excel spreadsheet to do monthly recalculations in excel
2000? For example: February $2.00 February $3.00 March $1.50 March $1.50 April $1.00 April $1.00 Then set up a report that shows all of February totals? Feb Mar Apr $5.00 $3.00 $2.00, etc. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Reculations in Excell
Dave
You are a star. The old ways are still the best; lovely to use the command prompt again and lo and beld it found another copy of that pdf file. No more nag screens in Excel now. Havn't found Start/Run in Vista but the comand prompt can be accessed frm Start/AllProgrames/Accessories.. Thanks again for your help and patience Philip "Nora Gaitan" <Nora wrote in message ... How do I set up an excel spreadsheet to do monthly recalculations in excel 2000? For example: February $2.00 February $3.00 March $1.50 March $1.50 April $1.00 April $1.00 Then set up a report that shows all of February totals? Feb Mar Apr $5.00 $3.00 $2.00, etc. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Reculations in Excell
I think you stole this thread.
But glad you found the addin. Philip Reece-Heal wrote: Dave You are a star. The old ways are still the best; lovely to use the command prompt again and lo and beld it found another copy of that pdf file. No more nag screens in Excel now. Havn't found Start/Run in Vista but the comand prompt can be accessed frm Start/AllProgrames/Accessories.. Thanks again for your help and patience Philip "Nora Gaitan" <Nora wrote in message ... How do I set up an excel spreadsheet to do monthly recalculations in excel 2000? For example: February $2.00 February $3.00 March $1.50 March $1.50 April $1.00 April $1.00 Then set up a report that shows all of February totals? Feb Mar Apr $5.00 $3.00 $2.00, etc. -- Dave Peterson |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Reculations in Excell
You could add headers
sort your data and do Data|subtotals But that report will be vertical. Maybe you could add headers and use data|pivottable to get that summary. Or even just formulas: =sumif(a:a,"January",b:b) (and so forth) Nora Gaitan wrote: How do I set up an excel spreadsheet to do monthly recalculations in excel 2000? For example: February $2.00 February $3.00 March $1.50 March $1.50 April $1.00 April $1.00 Then set up a report that shows all of February totals? Feb Mar Apr $5.00 $3.00 $2.00, etc. -- Dave Peterson |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Reculations in Excell
One method...............
Assuming your current data is in columns A and B In C1:E1 enter February through April In C2 enter =SUMIF(A1:A6,"February",B1:B6) Same for D2, E2 and change the month. Gord Dibben MS Excel MVP On Thu, 10 May 2007 10:29:01 -0700, Nora Gaitan <Nora wrote: How do I set up an excel spreadsheet to do monthly recalculations in excel 2000? For example: February $2.00 February $3.00 March $1.50 March $1.50 April $1.00 April $1.00 Then set up a report that shows all of February totals? Feb Mar Apr $5.00 $3.00 $2.00, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) |