I need to know calculate the total amount of cash collected per reference no
for each sales rep and input it into a different sheet.

The cash sheet might have the following info.

Ref CASH DATE

MUC01 £24.99 25/11/07

The cash sheet has many payments on it like this. I need to calculate the
total collected for that ref no - but in another sheet

The sales sheet may look like this:

Ref Total

Muc01

So in the total column I need it to refer to the cash sheet and tell me the
total of payments collected for that ref no.

i hope this is clear - I am not very good at explaining myself.
--
Kind regards
Megan


"Sandy Mann" wrote:

Speaking personally I don't quite understand what it is that you are trying
to do - I'm not one of the clever lot <g

Can you explain what it is that you want to do?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Megan" wrote in message
...
My formula isn't working and having tried to solve it for the past hour -
I'll not throw it out to you clever lot.

I have two worksheets. one is of cash recvd and is laid out like so
A B C D
DATE REF VALUE METHOD


the other worksheet is Sales rep info Laid out like so
B C D E
CONTRACT REF VAL TOTAL


What I am trying to do is work out the total collected per ref no: The
formula I have tried is =if(cashrecvd!$B2:B3000,TA!C2,$C2:$C3000)

Please can you help me is driving me insane?

many thanks in anticpation of your support

--
Kind regards
Megan