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

J

James

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and Match 8
How do I find a match for three variables to determine the result? 4
trying to find solution to copy duplicated data from one sheet to 12
find closest match and copy to sheet1 5
HELP! Find Data in columns next to known data then Calculate 2
Code reqd. to generate Loading Slip 3
Very Slow reading excel data into an array (while opened in new xl 17
Trying to Split and delete 1

Top