if statement

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
 
A

Andy Brown

"kevin",

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

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

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top