ExcelBanter - sumif when criteria range is larger but includes criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sumif when criteria range is larger but includes criteria (https://www.excelbanter.com/excel-programming/422578-sumif-when-criteria-range-larger-but-includes-criteria.html)

Joe1939

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

Mike H

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

All times are GMT +1. The time now is 05:18 PM.