sumif when criteria range is larger but includes criteria

  • Thread starter Thread starter Joe1939
  • Start date Start date
J

Joe1939

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with the criteria range 4
Criteria 4
Sumif using Arrays 2
Count With Criteria 9
SUMIF with criteria "<>" & "=" 4
sumif weekday 3
Sumif with Multiple Criteria 3
Delimma: SumIf worksheet function 0

Back
Top