=sumproduct(--(active!$P2:$P20029)--(active!$P2:$P200<50),active!$g2:$g200)

SP works on specific ranges, and they must be the same size

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lori Burton" wrote in message
...
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