Choosing info from one column based on another column

  • Thread starter Thread starter EdC
  • Start date Start date
E

EdC

I am currently trying to figure out how to make a formula that will pic
and choose certain information from one column based on the informatio
from another column.

For example, I have Column A and B. In column A, I am listing all o
the money I have made on each sale, and in column B I am listing th
person I sold it to. Now, I want aforumla which tells me tha
everytime I enter "Tim" in column B that it will take the value fro
the corresponding cell in column A and add it together. So if B5, B11
and B14 all equal "Tim" then the formula would only add together "A5
A11, and A14" while ignoring everything else in that column. But i
the next cell if B1, B9, and B20 all equal "Jake", then it will add th
values in A1, A9, and A20.

I tried to explain this as best I can. Hopefully someone here I ca
help me. thanks in advance
 
Hi Ed

try
=SUMIF(B1:B100,"Tim",A1:A100)
and likewise for all your other people
where B1:B100 is the range of names & A1:A100 is the range of people
Cheers
JulieD
 
Back
Top