What happens in this formula if there is no number in e1:e:50. Does the
average skip it or does it take a 0. If so, how would this formula look
different if you ask it to skip cells that are blank or have "0".
Thanks

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Roman" wrote in message
...
Thanks...That worked.

Cheers

"T. Valko" wrote:

Try these array formulas** :

=AVERAGE(IF(D1:D50="Jane",E1:E50))

=AVERAGE(IF((C1:C50="new")*(D1:D50="Jane"),E1:E50) )

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Roman" wrote in message
...
Hoping you can help me.

I have Column A with a start date and Column B with an end date.
Column C
has "New". Column D has the name "Jane". Column E has the number of
days
between A and B. I want to:

1. See the average number of days (e1:e50) for Jane only
2. See the average number of days (e1:e50) for only Jane that are only
New