Thread: sumif when criteria range is larger but includes criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe1939 Joe1939 is offline
external usenet poster
  
Posts: 2
Default sumif when criteria range is larger but includes criteria
Trying to sum values when the criteria range (text) is larger (more
characters) but includes the criteria. Example: Sumif(A1:A10,"BOS",B1:B10)
to also include B2 in sum when criteria range cell A2 is "BOS-336".

Regards,
JoeR
Reply With QuoteReply With Quote