Column A contains phone numbers. Column B contains the amounts I remunerated for the ring to that phone number. I want to know how much I salaried for business call. Phone numbers of my business partner are stored contained by Column C. How does the Excel formula look approaching (without using any VB code)?
Answers: clinky's formula is on the right track, but I contemplate it's for a moment backwards.
It should be:
=SUMIF($C$1:$C$100, A1, $B$1:$B$100)
You would put this somewhere contained by row 1 (e.g. D1), and copy it down.
It compares Ax (A1 within the example) next to every cell within C1:C100. Whenever nearby is a meeting, it includes the B expediency on indistinguishable row contained by the total. So if A1=C5, for example, B5 would be included in the sum.
If you inevitability more info, join more detail or e-mail.
Cheers.
.
=sumif(a1:a40,2485555555,b1:b40)
shift to Excel oblige sumif for more info