ExcelBanter - Formula error; was working

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula error; was working (https://www.excelbanter.com/excel-programming/425254-formula-error%3B-working.html)

Formula error; was working

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

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