add cells which contain blanks resulting from IF formulae

Hi,

Alternatively, if you've got a large range (let's say A3:BA3) you can do the below formula. It'll mean that even if there are error messages in your cells, Excel will only Sum the numbers. This is an array formula, so you need to press CTRL+SHIFT+ENTER to get it working. You'll get curly brackets around it to show it's an array:

=SUM(IF(ISNUMBER(A3:BA3),A3:BA3))

HTH,

SamuelT