New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
COURSE of the MONTH
11 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Modify sumproduct
Posted on 2011-03-04
This works fine:
=SUMPRODUCT((F12:F21>=C8)*
However, I need help in doing this:
If H12:H21 the value = N then do not add to this =SUMPRODUCT((F12:F21>=C8)*
=SUMPRODUCT((F12:F21>=C8)*
However, I need help in doing this:
If H12:H21 the value = N then do not add to this =SUMPRODUCT((F12:F21>=C8)*
[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
Featured Post
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…
Suggested Courses
Course of the Month11 days, 11 hours left to enroll
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.