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'
 
Top