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!