Having now worked, unsuccessfully, for the last 4 hours on a formula, I am wondering whether anyone can now help.
In cell A1 we need to check for the word "DECK" as the 1st four characters, if this is TRUE then we MAY need to amend it in cell A4. If it says DECK 1, DECK 2, DECK 3 and so on to...
I want to calculate a Sum/Total of all those cells that also contain some text strings For example:
Cell A1 has
Cell B1 has
Cell C1 has
So the total would be 10
But as this an example, it is pretty easy to calculate this manually but i have a long list of...