Hello,
I need to calculate the sum of cells in a column as below, eg
12
20
18*
4*
0
65*
10
Where the answer would be 129
In other words the total ignores the asterisks (and yes these are asterisks not wild cards)
Any assistance greatly appreciated, thanks.
Bookmarks