Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

EXCEL PROBLEMMMMMMMMMMM?

A B

1 John 55

2 John 45

3 Jack 50

4 Jill 23

5

6

when looking up John, what is the line of code that displays both A and D (not just A) in cell B6 or B6 and B7? do NOT direct me to a website, this is why I'm asking it here. I have searched but not understood what it was talking about.

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    i think the obvious question will refer to this part of your Question

    "displays both A and D"

    where does the D come from based on the example?

    what do you want to see in cell B6?

    do you want to see 100 (thats =55+45)? in that case you would use a sumif()

    =SUMIF(A1:A4,"John",B1:B4)

    feel free to update the question or email me.

Still have questions? Get your answers by asking now.