Formula

[Guest]

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

 

[Peo Sjoblom]

Sort the table by names, then use data>subtotal, for each change in A sum B

 

[T. Valko]

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 Data>Subtotals
At each change in name column
Use function SUM
Add subtotal to amount column