think i need sumproduct help
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
|