Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark R[_2_] Mark R[_2_] is offline
external usenet poster
  
Posts: 10
Default 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))


Reply With QuoteReply With Quote