Sum Product based on value
 

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!

Sum Product based on value
 

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

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mindy" wrote:

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!

Sum Product based on value
 

Hi,
what is in column J, is there any blanks

"Mindy" wrote:

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!