Thread: Formula using SUMIF & IF
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Formula using SUMIF & IF
Oops, slight correction, should be:

=SUMPRODUCT((A6:A390=B5)*(A6:A390<=B6)*ISNUMBER(S EARCH("8in",F6:F390)),E6:E
390)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote