Thread: sumif when criteria range is larger but includes criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default sumif when criteria range is larger but includes criteria
see your other post

"Joe1939" wrote:

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