ExcelBanter - Find and match totals Genius Req. this should be easier to read

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find and match totals Genius Req. this should be easier to read (https://www.excelbanter.com/excel-worksheet-functions/48406-find-match-totals-genius-req-should-easier-read.html)

Find and match totals Genius Req. this should be easier to read

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 !!!

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 !!!