Sum Product based on value

M

Mindy

Hi,

I am trying to sum the number of divisions based on work area category. If
work area category (K6:K169) is 1, then count division number (column
J6:J169). I tried the below formula, but keep getting 0 as my value.
(Should be somewhere in 130's).

=SUMPRODUCT((K6:K169="1")*(J6:J169))

Any help is appreciated!
 
L

Luke M

Take the quotes off of the 1. (you're looking for a number, not text)

=SUMPRODUCT((K6:K169=1)*(J6:J169))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
sum product if 2
Summing data between two date criteria 5
SUMPRODUCT 3
Subtotal and IF Formula 1
sum based on value in a range 0
Using SUM(INDIRECT()) 2
sumproduct 3

Top