HI everyone, I have a range of cells in rows and columns.
I want to be able to sum each row between A and E.
The thing is that sometimes A,B,C,D or E contains a letter, and this results in #VALUE! result.
Is it possible to change the formulae from a simple sum(A1:E2) etc to something which will exclude those cells where the character is a letter and only sum where the character is a number.
Thanks for your help
Love Amy xx
Bookmarks