sumproduct

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parsing text 1
UNexpected NPER results 4
Mortgage Spreadsheet 4
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),... 8
Adjustable Rate APR 4
SUMPRODUCT column criteria 2
Scrabble Value calculation for Welsh words 0
SumProduct 2

Top