Originally Posted by azonicds2

Hi

I have what hopefully is a simple question. I have a forumla:

=IF(COUNTA(INDIRECT("D3:M3"))3,"Training",COUNTA( INDIRECT("D3:M3")))

That works perfectly, but when i copy it down, it doesnt update the cell numbers, eg:

=IF(COUNTA(INDIRECT("D3:M3"))3,"Training",COUNTA( INDIRECT("D3:M3")))
=IF(COUNTA(INDIRECT("D4:M4"))3,"Training",COUNTA( INDIRECT("D4:M4")))
=IF(COUNTA(INDIRECT("D5:M5"))3,"Training",COUNTA( INDIRECT("D5:M5")))

I have made sure that workbook calculation is set to "Automatic" as well as i know thats the most common mistake.

Can anyone help me?

Thanks very much

Danny