need a formula

[Guest]

hi all,i have a list of names in column a, each name has a different number.the number will be in column b
this data is entered daily and has to be totaled at the end of each month.is there a formula i can used to total each individual persons numbers.thanks in advance.slowm

john
rick
brad
john
rick
brad

 

[JMay]

Check out the feature at the Menu - Data Sub-totals...

hi all,i have a list of names in column a, each name has a different

number.the number will be in column b.

this data is entered daily and has to be totaled at the end of each

month.is there a formula i can used to total each individual persons
numbers.thanks in advance.slowmo

 

[Bob Phillips]

=SUMIF(A:A,"John",B:B")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

hi all,i have a list of names in column a, each name has a different

number.the number will be in column b.

this data is entered daily and has to be totaled at the end of each

month.is there a formula i can used to total each individual persons
numbers.thanks in advance.slowmo

 

[Ken Wright]

Data needs to be sorted on the name field though if using that route.

 

[Ken Wright]

Pivot table is another nice option:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

hi all,i have a list of names in column a, each name has a different

number.the number will be in column b.

this data is entered daily and has to be totaled at the end of each month.is

there a formula i can used to total each individual persons numbers.thanks in
advance.slowmo

 

[Guest]

hi jmay,that works.thank you for your help.slowm

----- JMay wrote: ----

Check out the feature at the Menu - Data Sub-totals..

hi all,i have a list of names in column a, each name has a differen

number.the number will be in column b

this data is entered daily and has to be totaled at the end of eac

month.is there a formula i can used to total each individual person
numbers.thanks in advance.slowm