I've been all around and tried many suggestions but still can't make this work.

Looking at one column of numbers on a separate worksheet that should be
greater than 29 but less than 50, and if they meet this criteria I want the
sum of another column of numbers on the separate worksheet added.

I've tried
sumproduct(--active!$P:$P29)*--(active!$P:$P<50),active!$g2:$g200)

it returns #NUM! as an answer

I have double checked and there are no errors or text entered in the G column
--
Lori