Thread: HELP!!!!!!!!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bumblebug787 bumblebug787 is offline
external usenet poster
 
Posts: 3
Default HELP!!!!!!!!

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.