I am currently using the following formula, but due to the size of the spreadsheet now I would to drag the formula down the page without it populating the rows that are blank. Please can anyone help?

=IF(O10="",X10,IF(X10="",O10+Q10+S10))

Cheers

Richard