Posted to microsoft.public.excel.worksheet.functions

Coley

external usenet poster

Posts: 7

Sumproduct

I can't seem to make SUMPRODUCT work with a date field as a criteria.

SUMPRODUCT(range="x")*(range="9/1/07")
I would like for the date range to look for "*/5/*" ie. amy month, any year.
If I change the range and look for words in that range it works. I just
can't seem to get it to work with a date.

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
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
SUMPRODUCT?	Joey041	Excel Worksheet Functions	2	November 20th 06 11:35 PM
using -- with SUMPRODUCT	Dave F	Excel Discussion (Misc queries)	13	November 15th 06 05:50 PM
Sumproduct	Denise	Excel Discussion (Misc queries)	4	October 20th 05 02:09 AM
Help with SUMPRODUCT	FrankTimJr	Excel Discussion (Misc queries)	4	October 12th 05 04:27 PM

All times are GMT +1. The time now is 12:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us