About
Pricing
Community
Teams
Start Free Trial
Log in
Frank Freese
asked on
3/4/2011
Modify sumproduct
This works fine:
=SUMPRODUCT((F12:F21>=C8)*
(F12:F21<F
8)*(G12:G2
1))
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<F
8)*(G12:G2
1))
Microsoft Excel
5
1
Last Comment
Frank Freese
8/22/2022 - Mon
McOz
3/4/2011
Use the formula:
=SUMPRODUCT((F12:F21>=C8)*
(F12:F21<F
8)*(G12:G2
1)*(H12:H2
1<>N))
Cheers
ASKER CERTIFIED SOLUTION
McOz
3/4/2011
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
3/4/2011
ASKER
I got a return "False"
Frank Freese
3/4/2011
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
3/4/2011
ASKER
thank you
=SUMPRODUCT((F12:F21>=C8)*
Cheers