Formula
Maybe this:
=SUMIF(A$1:A$10,"Bob",B$1:B$10)
Or:
D1 = Bob
=SUMIF(A$1:A$10,D1,B$1:B$10)
Or:
Select your range of data
Goto DataSubtotals
At each change in name column
Use function SUM
Add subtotal to amount column
--
Biff
Microsoft Excel MVP
"Kris" wrote in message
...
Is there a formula that will sum a column based on another column?
Example: Two columns: A has names of people B has amounts of pay for
those
people. Is there a formula that will pull a subtotal for each person in
column A
|