View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Yes, you can do =SUMIF(B3:B20,IF(H110,5,6))

--

HTH

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


"peter" wrote in message
...