Formula error; was working
You are ending up with a Row Number that is a fraction because K44 is odd and
not divisible by 2. 36 is even and 11 is odd.
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&TODAY()+INT(K44/2))))/7))
"El Bee" wrote:
I have a formula that was working last week and today I get the ominous #REF!
error.
The value in cell K44 equals 11
Here's the formula:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&TODAY()+(K44/2))))/7))
Last week the value in cell K44 equaled 36; don't know if this helps.
Thanks for looking.
El Bee
|