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

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