How do I exclude empty cells when trying to average columns? I am doing a
large sheet of date differences and want to exclude any empty cells from the
calculations.

The AVERAGE function excludes BLANK cells - what is your formula?

"bumblebug787" wrote:

How do I exclude empty cells when trying to average columns? I am doing a
large sheet of date differences and want to exclude any empty cells from the
calculations.

Well, the problem is that I do have the start date listed - but the end date
is blank. I am wanting an average of mowing cycles - I have a start date for
each cycle, but not an end date yet. Is there a way to find the average for
just those with an end date?

"Toppers" wrote:

The AVERAGE function excludes BLANK cells - what is your formula?

"bumblebug787" wrote:

How do I exclude empty cells when trying to average columns? I am doing a
large sheet of date differences and want to exclude any empty cells from the
calculations.

If your date difference is calculated in a separate cell, then test if no end
date and cell to blank.

You can then AVERAGE the date diff column

Column A = Start date
Column B = End date
Column C = Date difference:

=IF(B2="","",B2-A2)

AVERAGE column C

HTH

"bumblebug787" wrote:

Well, the problem is that I do have the start date listed - but the end date
is blank. I am wanting an average of mowing cycles - I have a start date for
each cycle, but not an end date yet. Is there a way to find the average for
just those with an end date?

"Toppers" wrote:

The AVERAGE function excludes BLANK cells - what is your formula?

"bumblebug787" wrote:

How do I exclude empty cells when trying to average columns? I am doing a
large sheet of date differences and want to exclude any empty cells from the
calculations.