Avatar of Frank Freese
Frank Freese
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
Frank Freese

8/22/2022 - Mon
McOz

Use the formula:

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

Cheers
ASKER CERTIFIED SOLUTION
McOz

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Frank Freese

ASKER
I got a return "False"
Frank Freese

ASKER
woops - my mistake - it look  goodv thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Frank Freese

ASKER
thank you