Formula
 

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

Formula
 

Sort the table by names, then use datasubtotal, for each change in A sum B


--

Regards,

Peo Sjoblom

"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

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