Posted to microsoft.public.excel.programming

external usenet poster

Posts: 58

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error on Working Macro	cschultz25	Excel Discussion (Misc queries)	0	February 11th 11 07:20 PM
On Error Not Working...	egun	Excel Programming	1	September 30th 08 11:49 PM
Error Trap not working	OssieMac	Excel Programming	4	April 2nd 08 01:55 PM
Why isn't my error handling working?!	tercerojista	Excel Programming	9	May 4th 07 04:13 PM
error 50290 when working from dll	PM	Excel Programming	0	November 18th 04 10:05 AM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us