DIV/O

[John Bruel]

I tried you formula, but I get DIV/O.

Note that my dates are in DATE format, not text. In your
formula, am I suppose to replace the TEXT and ddd by
somthing else?

John

 

[Harlan Grove]

I tried you formula, but I get DIV/O.

Note that my dates are in DATE format, not text. In your
formula, am I suppose to replace the TEXT and ddd by
somthing else?

Who the @#$% are you responding to? Respond to the responses to your
original question in the *SAME* thread. Don't start new ones.

 

[Frank Kabel]

Hi Joel
I definetly agree with Harlan to stay in the existing thread. But you
probably meant Bob's formula:
=SUMPRODUCT((TEXT(A1:A11,"ddd")="Mon")*B1:B11)/SUMPRODUCT(--(TEXT(A1:A1
1,"ddd")="Mon"))

This should work but you may try the following solution form Harlan and
me (note: use Harlan's solution -> shortest and probably fastest way):

--------
=SUMPRODUCT(--(WEEKDAY(A1:A11)=2),B1:B11)/SUMPRODUCT(--(WEEKDAY(A1:A11)
=2))

Harlan's solution: Array formula to be entered with CTRL+SHIFT+ENTER)
=AVERAGE(IF(WEEKDAY(A1:A11)=2,B1:B11))