View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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