If multiple cells contain value then add value [Solved/Closed]

Robert Bell - Jul 27, 2016 at 04:10 AM - Latest reply:  Rob
- Aug 3, 2016 at 10:32 AM
Trying to think of the best way to sort this problem!
I have a spreadsheet with a list of customers that have purchased a vehicle.
Along side information I then list whether they've collected the vehicle and if it has any EXTRAS on there (3 possible for each vehicle)
Each extra has a worth of £25
Each car sold has a worth of £15
In the car sold list I currently have this formula:
Where essentially it adds 15 everytime to the car sold cell once a collection date (A1) is present
I then have a grand total cell that sums all £15's in the cars sold column together with a simple SUM formula
Now my question is, is there a way for me to use a similar IF formula where if there's text in the extras cells to sum together in one column
I tried
Which only counts if there's something in every of the 3 extra cells, is there a way I can sum only the cells that contain text and ignore the others that do not with a if false formal perhaps?

See more 

2 replies

Mazzaropi 1794 Posts Monday August 16, 2010Registration dateContributorStatus March 19, 2018 Last seen - Jul 27, 2016 at 09:51 AM
Robert Bell, Good morning.

a) Change the "" to zero

b) Try to use another formula

Is this what you want?
I hope it helps.
That's exactly what I needed, simple fix

Cheers mate