=SUMIF(sheet2!B2:B10,"<",sheet2!A2:A10)





Brandon wrote:

I have two columns:
A B
205 Johnny Smith
120 Gerald Jones
284
179 Frank Bend

What function can I use... to say if there is a value in column B, I want
you to add the corresponding value of column A

Im making a template, so it references another sheet:

=SUMIF(Sheet2!B2:B10, COUNTA(Sheet2!B2:B10), Sheet2!A2:A10)

and it just isn't working.

--

Dave Peterson