?
Solved

Modify sumproduct

Posted on 2011-03-04
5
Medium Priority
?
239 Views
Last Modified: 2012-06-21
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))
0
Comment
Question by:Frank Freese
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:McOz
ID: 35038355
Use the formula:

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

Cheers
0
 
LVL 9

Accepted Solution

by:
McOz earned 2000 total points
ID: 35038371
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
 

Author Comment

by:Frank Freese
ID: 35038457
I got a return "False"
0
 

Author Comment

by:Frank Freese
ID: 35038467
woops - my mistake - it look  goodv thanks
0
 

Author Closing Comment

by:Frank Freese
ID: 35038470
thank you
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question