Hi,
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
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