Sum Product based on value

[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!

 

[Luke M]

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

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

 

[Eduardo]

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