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.