Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|