Sumif cell contains a certain value

N

NV

I am trying to sum a range of numbers if the adjoining
cells contain a certain text. How do I do that?
 
F

Frank Kabel

Hi
try something like
=SUMIF(A:A,1,B:B)
sums all values in column B if column A contains a '1'
 

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 criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
sumif issues 1
Excel Countif Function - Calculating Between Two Sets of Values 3
SumIf equation question 6
Count If 4
cell vlue based on cell back colour 7
Paste to excel from word - auto format problem 1

Top