SUMIF? using contains

L

LAN186

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.
 
M

Mike H

Maybe

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

Mike
 

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

Combining same data in multiple rows 4
sumif column contains text 7
Problem in SUMIF Function 1
Extracting from a List 1
Count unique values 5
counting blank cells within two columns 2
Transpose large column 3
SumIF or SumProduct 2

Top