Yeah, but you knew also, which is more important <G

Bob

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks bob, i knew you would know.

--


Gary


"Bob Phillips" wrote in message
...
Yews it would, as long as both criteria have to be satisfied.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
would this be the solution?

=SUMPRODUCT(--(G24:G360=G204),--(V24:V360=V204),E24:E360)

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i have an original formula:
=SUMIF(G$24:G$360,G204,E$24:E$360)

but now i need to base it on 2 criteria, the other being if v204 is
in
the
range of v24:v360

this gave me the count,
=SUMPRODUCT(--(G24:G360=G204),--(V24:V360=V204))
but i need to find the sum of the 2 criteria in range e24:e360


--


Gary