Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


andysh

228 posts

Master Geek


#30903 25-Feb-2009 11:05
Send private message

Hey,

Just got a problem. I have got a list of names in one column, and a list of numbers in the column. I want to add the numbers up where the names match.

E.G

Bob  5
Mary 4
Bob  3


Bob's total would be 8, mary's would be 3. Guess you would have to use a match and sum functions, maybe if?

Thanks for the help,

Andysh





Referrals:

 

Tesla: https://ts.la/andrew897313

 

Sharesies: https://sharesies.com/r/XRGS77 


Create new topic
bazzer
3438 posts

Uber Geek

Trusted

  #197953 25-Feb-2009 11:13
Send private message

Just use a PivotTable?



Balchy
484 posts

Ultimate Geek

Trusted

  #197954 25-Feb-2009 11:16
Send private message

Countif?





For billions of years since the outset of time, every single one of your ancestors survived, every single person on your Mum and Dads side, successfully looked after and passed onto you life.  What are the chances of that like?

stevonz
397 posts

Ultimate Geek

Trusted

#197958 25-Feb-2009 11:31
Send private message

Use the subtotal function...

Sort your data by name, highlight the data, then file menu Data> Subtotals

Select At each change in; Name 
Use function: Sum
Add subtotal to: Count




Cheers, Stevo



nzjwnz
40 posts

Geek


  #197960 25-Feb-2009 11:31
Send private message

Sumif

e.g. assuming names are in column A and number in B

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


andysh

228 posts

Master Geek


  #197969 25-Feb-2009 11:53
Send private message

Thanks all,

I went with the Sumif, seems very simple and works great. Thanks nzjwnz

Andysh




Referrals:

 

Tesla: https://ts.la/andrew897313

 

Sharesies: https://sharesies.com/r/XRGS77 


bazzer
3438 posts

Uber Geek

Trusted

  #197970 25-Feb-2009 12:04
Send private message

The  downside is you have to hardcode each name that appears in the list, don't you?  Same with countif (which doesnt solve your problem anyway).


The problem with subtotals is if you add new entries, you have to remove and resort etc.


PivotTable beats all!  Just my opinion, of course.  People don't use PivotTables enough...


nzjwnz
40 posts

Geek


  #197986 25-Feb-2009 13:09
Send private message

No worries andysh

bazzer:

The  downside is you have to hardcode each name that appears in the list, don't you?  Same with countif (which doesnt solve your problem anyway).


The problem with subtotals is if you add new entries, you have to remove and resort etc.


PivotTable beats all!  Just my opinion, of course.  People don't use PivotTables enough...



or you can just point it to a cell where the name already exists e.g. =SUMIF(A:A,C1,B:B) where C1 is say bob

I agree that a pivot table is often the best solution though.

Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.