View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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