hi
have several lines in a workbook as i need to take an eaverage of performance each day and then transfer the info to a summary sheet when the fields have at least one nuber above zero it works ok but at the start of the week we start a new sheet. giving the dreaded div/o error i know you can use the IF command to get rid of this but unsure how to implement it.
this is an example
=SUM('Tuesday nights'!B20:B28)/COUNTIF('Tuesday nights'!B20:B28,"<>0")
have a string like this for days and nights sunday through saturday then another for the summary.
would be grateful for any help
Kerrrie
have several lines in a workbook as i need to take an eaverage of performance each day and then transfer the info to a summary sheet when the fields have at least one nuber above zero it works ok but at the start of the week we start a new sheet. giving the dreaded div/o error i know you can use the IF command to get rid of this but unsure how to implement it.
this is an example
=SUM('Tuesday nights'!B20:B28)/COUNTIF('Tuesday nights'!B20:B28,"<>0")
have a string like this for days and nights sunday through saturday then another for the summary.
would be grateful for any help
Kerrrie