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