#### stacey_milesg

##### New Member

- Joined
- Mar 18, 2019

- Messages
- 14

I am very new to excel and am looking for some help! Id really appreciate if someone can help me with a formula for one of my cells.

I have a cash book, in column B it has details of the person paying the money in. This money is usually for one client but sometimes it can be for more that one so I have to split the amounts which I do so Im column E, eg B9 will say John Smith and then E9 will have a figure and E10 will have a figure but I leave B10 as a blank field. I need a formula so that F9 will add E9&E10 only when B10 is blank. If it is not blank then it should only pull E9. However it could be that one receipt could be for 5 clients and so I need the formula to add all of those and then work down for the whole spreadsheet.

Im sorry if this sounds very confusing! Its hard for me to explain!

Thank you in advance for your help!!