On Tue, 27 Nov 2007 04:33:00 -0800, Megan
wrote:

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


Your formula is an array-formula. Are you "committing it" with
<ctrl<shift<enter and is Excel placing the braces {...} around it?

Since you seem to have REF on both sheets, perhaps you could just use one sheet
and a SUMIF formula.
--ron