Related: AVERAGE

[Josh W.]

I've made a template relying heavily on averages. The problem is,
when an employee didn't work on a certain day, and therefore had no
data, all I end up with is this: # # # #, which messes with other
formulas.

For example: Yesterday Jeff drove a tour with a 3 rating, and a tour
with a 2 rating. (AVERAGE: 2.5) Today Jeff had the day off. (AVERAGE:
# # # #). The Average for the two days: # # # #.

I want Jeff's day off NOT to count in the average. SO, average of day 1
would be 2.5, average of day 2 would be N/A, and total average would
be 2.5. How to do this?

Thanks!

 

[Bob Greenblatt]

I've made a template relying heavily on averages. The problem is,
when an employee didn't work on a certain day, and therefore had no
data, all I end up with is this: # # # #, which messes with other
formulas.

For example: Yesterday Jeff drove a tour with a 3 rating, and a tour
with a 2 rating. (AVERAGE: 2.5) Today Jeff had the day off. (AVERAGE:
# # # #). The Average for the two days: # # # #.

I want Jeff's day off NOT to count in the average. SO, average of day 1
would be 2.5, average of day 2 would be N/A, and total average would
be 2.5. How to do this?

Thanks!

Do you really mean "# # #"? Is this a string you enter in the cell? Or, do
you get "###", Excel's indication that the column is too narrow? If the
latter, perhaps a formula is generating an error that doesn't show in the
column. Average does not consider blank or non numeric values in the average
calculation.