Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help on excel sheet formula
I want the formula from one worksheet to another worksheet Example:-
one row Date 03/12/07 is there and at the same coloum number is (1) given and another row the same date 03/12/07and the number (2) is there, I want the formula to calculate the date wise and the number coloum, the number in another worksheet. as the total 3 in one row |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help on excel sheet formula
Assuming your source data sheets are named as: Sheet1 & Sheet2 (say), both
sheets identically structured with dates in col A, amounts to be summed in col B In your summary sheet (another sheet), In A2 down you have the dates: 12/3/2007, 12/3/2007, etc You could place in B2: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B)+SUMIF(Sheet2!A:A, A2,Sheet2!B:B) Copy B2 down as far as required. Adapt/extend to suit. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Maxofus" wrote: I want the formula from one worksheet to another worksheet Example:- one row Date 03/12/07 is there and at the same coloum number is (1) given and another row the same date 03/12/07and the number (2) is there, I want the formula to calculate the date wise and the number coloum, the number in another worksheet. as the total 3 in one row |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put VBA formula in Excel Sheet | New Users to Excel | |||
Is there a formula which will print the sheet name in Excel? | Excel Discussion (Misc queries) | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
Need help to set-up a formula on Excel work sheet? | New Users to Excel |