- Feb 17, 2002
Hi Guys, I want to sum a range across a number of columns some of which contain numbers and some contain blanks (e.g. =IF(a1="","",B1) which is all well and good until I come to sum across the columns - I get an #VALUE! error. Can you help. Regards Nigel.