Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag 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))
Avatar of McOz
McOz

Use the formula:

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

Cheers
ASKER CERTIFIED SOLUTION
Avatar of McOz
McOz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Freese

ASKER

I got a return "False"
woops - my mistake - it look  goodv thanks
thank you