ExcelBanter - sumproduct

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumproduct (https://www.excelbanter.com/excel-discussion-misc-queries/153316-sumproduct.html)

Mark R[_2_]

sumproduct

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_]

sumproduct

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

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