hi
i have an excel file to store all the offer details of my work in a
financial year.
ón sheet1 i have all the deatils oh the sales report and on sheet two i make
the revenue calculations for each month separately.
for eg if col A of sheet1 has the dates of the transactions and col C has
the individual prices.
then for each month in sheet2 how do i sum upthe total price depending upon
the dates only in that particular month
that is if month september starts at A45 and ends at A256 in sheet1. it
should check rows in A for date n then accordingly sum the range of values
in col C.
here it shud do it from C45 -- C256
and i want the´sum in any one of the cells in sheet two
thankin in advance

Hi

It sounds as though your data would be ideal to use for a Pivot Table.
This will permit you to show your totals by month very easily.
For help on how to set up Pivot Tables, take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and
http://www.contextures.com/tiptech.html

If you want to do it by formulas, then one way would be to put Month numbers
1 to 12 in cells A1:A12 of sheet2 then in cell B1 of Sheet2 enter
=SUMPRODUCT(--(MONTH(Sheet1!$A$1:$A$1000)=A1),Sheet1!$C$1:C$C100 0)

copy the formula down through cells B2:B12

Change ranges to suit, but do ensure both ranges are of equal size.


Regards

Roger Govier


vidhya wrote:
hi
i have an excel file to store all the offer details of my work in a
financial year.
ón sheet1 i have all the deatils oh the sales report and on sheet two i make
the revenue calculations for each month separately.
for eg if col A of sheet1 has the dates of the transactions and col C has
the individual prices.
then for each month in sheet2 how do i sum upthe total price depending upon
the dates only in that particular month
that is if month september starts at A45 and ends at A256 in sheet1. it
should check rows in A for date n then accordingly sum the range of values
in col C.
here it shud do it from C45 -- C256
and i want the´sum in any one of the cells in sheet two
thankin in advance