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