DIV/O

  • Thread starter Thread starter John Bruel
  • Start date Start date
J

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
 
John Bruel said:
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?
Click to expand...

Who the @#$% are you responding to? Respond to the responses to your
original question in the *SAME* thread. Don't start new ones.
 
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))
 
Back
Top