View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.datamap,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Sunny[_3_] Sunny[_3_] is offline
external usenet poster
 
Posts: 10
Default Help in conditional SUM

Hi all,

I have two sheets in my spreadsheet. On first sheet I want to display
summarray of second sheet.

Here is the example:

Sheet1:

Month Sales
January 425.00
February 300.00
March 0.00
April 400.00
....
....
....
Total

Sheet2
SaleDate Amount
1/3/03 100.00
1/5/03 200.00
1/10/03 125.00
2/3/03 25.00
2/10/03 275.00
4/5/03 250.00
4/15/03 150.00
....
....
....

Can anyone give me idea?

Thanks.