Modify sumproduct

This works fine:
=SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21))
However, I need help in doing this:
If H12:H21 the value = N then do not add to this =SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21))
Frank FreeseAsked:
Who is Participating?
 
McOzConnect With a Mentor Commented:
Oops! I should have said, use this:

=SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21)*(H12:H21<>"N"))

(with the value in quotes)

-Oz
0
 
McOzCommented:
Use the formula:

=SUMPRODUCT((F12:F21>=C8)*(F12:F21<F8)*(G12:G21)*(H12:H21<>N))

Cheers
0
 
Frank FreeseAuthor Commented:
I got a return "False"
0
 
Frank FreeseAuthor Commented:
woops - my mistake - it look  goodv thanks
0
 
Frank FreeseAuthor Commented:
thank you
0
All Courses

From novice to tech pro — start learning today.