Multiple IF functions

Hi

See attached spreadsheet, I need formulae throughout cells I2 to T67 that looks that if an order is placed (E) in a certain month then put the deposit amount (AA) in that cell. If a dispatch (F) is made in a certain month then the balance (AB) needs putting in the cell. I have used an =IF with & formula but it obviously isn't correct because the totals don't add up at the end

I'm sure it's a simple tweak but i can't figure it out, I believe it might be because the IF function is returning text which can't be added up?

Thanks

Pete

Change the ampersand ( & ) to plus ( + ) in cell I2, then copy across and down to give you proper numbers.

Hope this helps.

Pete

Try attached sheet

Perfect, works a treat! Thanks for your help

You're welcome

You're welcome, Pete, thanks for the rep.

Pete