About Us

Mark R[_2_]

Hi,

This formula is returning a #VALUE. Can anyone see an error in it

=SUMPRODUCT(--(Mortgages!$C$17:$C$997<""),--(Mortgages!$F$17:$F$997="A&l"),--(YEAR(Mortgages!$K$17:$K$997)=2007))

David Biddulph[_2_]

Perhaps your K range contains text rather than dates?
--
David Biddulph

"Mark R" wrote in message
...
Hi,

This formula is returning a #VALUE. Can anyone see an error in it

=SUMPRODUCT(--(Mortgages!$C$17:$C$997<""),--(Mortgages!$F$17:$F$997="A&l"),--(YEAR(Mortgages!$K$17:$K$997)=2007))

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
Help with SUMPRODUCT?	Gazzr	Excel Worksheet Functions	4	June 30th 06 02:16 AM
SUMPRODUCT	PaulW	Excel Discussion (Misc queries)	3	March 29th 06 12:27 PM
IF/AND used with SUMPRODUCT?	Amy via OfficeKB.com	Excel Worksheet Functions	2	January 16th 06 07:12 PM
Sumproduct	Steved	Excel Worksheet Functions	4	July 15th 05 07:22 AM

Menu

About Us