ExcelBanter - SUMIF? using contains

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMIF? using contains (https://www.excelbanter.com/excel-discussion-misc-queries/192548-sumif-using-contains.html)

LAN186

SUMIF? using contains

I have two columns A) product description & B) number sold. I want to search
column A (product description) for a specific word or number and where
successful I want to count column B.

Mike H

SUMIF? using contains

Maybe

=SUMIF(A1:A5,"*word*",B1:B5)
sums column B if col A contains a string with Word in

Mike

"LAN186" wrote:

I have two columns A) product description & B) number sold. I want to search
column A (product description) for a specific word or number and where
successful I want to count column B.

All times are GMT +1. The time now is 03:35 PM.