Look at the SUMIF function, and also at Pivot Tables.

On Mon, 3 Oct 2005 18:55:19 +0000 (UTC), "James"
wrote:

On a daily basis I receive a spread sheet

my problem is

How do i Get totals from each number to export into 1 cell on a sheet called
"demo".


Col R Col H
180 0.048
180 0.0784
180 0.083
180 0.059
192 0.0568
192 0.268
194 1.256



1st Oct
Calls 180 Calls 192
0 £0.00 0 £0.00
Calls 180 Calls 192
0 £0.00 0 £0.00


Calls 180 Calls 192
0 £0.00 29 £1.45


I have a current formula that does this perfectly but only if there is 1
report per number, i need to total all reports per number per day.
Current Formula is

=IF(ISNA(MATCH($C$3,OFFSET(demo!$C$1:$C$100,(ROW( 1:1)-1)*100,0),0)),0,INDEX(OFFSET(demo!$I$1:$I$100,(ROW (1:1)-1)*100,0),MATCH($C$3,OFFSET(demo!$C$1:$C$100,(ROW( 1:1)-1)*100,0),0)))

HELP !!!