Hi all, im sure this is a simple one but I cant seem to work it out
I have multiple cells, not in a row, so A1 D1 G1 J1, which I want to add together, but these cells have the formula
which could return a blank, the problem is when is comes across a blank it then gives me the #value error, any ideas of getting around that pleasePlease Login or Register to view this content.
Bookmarks