if statement

  • Thread starter Thread starter kevin
  • Start date Start date
K

kevin

i have a vertical data field with names "sally, jesse,
mike" going from a1 to a3. there are values going from b1
to b3 that correspond with those names. I want to have a
summary field at the bottom that states..." if the "a"
field says a certain name than add the corresponding
number. help
 
"kevin",

=SUMIF(A1:A3,"Sally",B1:B3)

The second argument in the brackets can be actual text or a cell reference.

Rgds,
Andy
 
Back
Top