Sum Product based on value

  • Thread starter Thread starter Mindy
  • Start date Start date
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!
 
Take the quotes off of the 1. (you're looking for a number, not text)

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