#n/a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please tell me why the following formula is returning #n/a?

=SUMPRODUCT(--($J$12:$J$1000 >=2),--($A$12:$A$1000 ="1"),($K$12:$K$1000))

Thanks for your time and help,
Steve
 

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

Scrabble Value calculation for Welsh words 0
SUM if with 3 criteria 2
function help, sumif?? 2
Formula returning an error 2
Sumproduct gives #value 6
Formulas Still Not Working 5
SUMIFS formula with 3 OR Conditions 3
Simple Question Complicated Formula 1

Back
Top