Solved

# SUMPRODUCT Formula/ Count

Posted on 2011-05-05
221 Views
Hi,

I have the following sumproduct formula which does its job and is working fine.

The formula result is a sum of the numbers Col C relating to Asset Services which are under 30days i Col K . I would like to change that so it COUNTS the entries that match the condition "Asset Services" (Col C) and <30 (Col K)

Thanks
Seamus
0
Question by:Seamus2626

LVL 33

Expert Comment

Formula?!?
0

Author Comment

=SUMPRODUCT(--(\$C\$2:\$C\$5000="ASSET SERVICES"),--(\$Q\$2:\$Q\$5000),--(\$K\$2:\$K\$5000<30))
0

LVL 33

Accepted Solution

=SUMPRODUCT(--(\$C\$2:\$C\$5000="ASSET SERVICES"),--(\$K\$2:\$K\$5000<30))
0

Author Closing Comment

Thanks Jppinto!!
0

## Join & Write a Comment Already a member? Login.

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

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

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

#### Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!