Formula error; was working

  • Thread starter Thread starter El Bee
  • Start date Start date
E

El Bee

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
 
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))
 
Back
Top