SUMIF Statement with Non-Contiguous Cells

[Snake Eyes]

I have non-contiguous cells that I would like to look for a specific value "Security".
'B18','B28','B38','B48','B58','B68','B78','B88','B98','B108'

When they contain that value (and only if they meet that criteria), I would like to add the number values of the cells to the right of those qualified cells only...
C18,C28,C38,C48,C58,C68,C78,C88,C98,C108
I suspect I need to use some combination of SUMIF and INDIRECT however, I can't seem to find the proper syntax.
Any help would be appreciated.

 

[jasonb75]

Is "Security" likely to be found in any of the other rows? If not then it would be easier and more efficient to simply use SUMIF on the whole range B18:B108 and C18:C108 respectively.

 

[Snake Eyes]

So I tried this

=SUMIF(B18:B108,"Security",C18:C108)

however, it returns a blank cell even though a few of those cells have number values.
The range in Col C is a mix of numbers and text.
How do I sum the specific cells in the Col C range?

 

[Snake Eyes]

So I tried this

=SUMIF(B18:B108,"Security",C18:C108)

and it works. I had a typo in the formula.
Thanks Jason75

 

[jasonb75]

If it doesn't return a result then you don't have any valid numbers in that range where the rows meet the criteria.

So I tried this

=SUMIF(B18:B108,"Security",C18:C108)

however, it returns a blank cell even though a few of those cells have number values.
The range in Col C is a mix of numbers and text.
How do I sum the specific cells in the Col C range?

edit:- think our replies crossed, glad you got it working.