+ Post New Thread
Results 1 to 5 of 5
Windows Thread, Excel Formula Help in Technical; Hi I am having a real mental blank as to what formula to use in excel. I have a spreadsheet ...
  1. #1
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,155
    Thank Post
    131
    Thanked 54 Times in 47 Posts
    Rep Power
    38

    Excel Formula Help

    Hi

    I am having a real mental blank as to what formula to use in excel.

    I have a spreadsheet where in the A column i have a list of usernames (repeated) and in the B column i have values. Basically they are print logs of what has been printed last half term. I want to total up for each user who has printed the most and then try and pursuade SLT to let me install print credits!

    Eg:
    A B
    test1 5
    test2 3
    test1 7
    test3 1
    test2 6

    Hope that makes sense, it needs to be a formula that i can type into one cell or one that i can drag down. as it is 18000 rows of data!!

    Cheers

    Dan

  2. #2
    Iain's Avatar
    Join Date
    Oct 2006
    Location
    Warwickshire
    Posts
    197
    Thank Post
    28
    Thanked 98 Times in 56 Posts
    Rep Power
    36

    Re: Excel Formula Help

    Would the SUMIF funtion work for you? E.g.

    Code:
    =SUMIF(A1:A5,"test1",B1:B5)
    Should give the the sum of the values in column B where the value in column A is equal to test1.

    Hope that is of some help,

    Iain.

  3. #3
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,155
    Thank Post
    131
    Thanked 54 Times in 47 Posts
    Rep Power
    38

    Re: Excel Formula Help

    Thanks Iain that works a treat. 8)

  4. #4

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,345
    Thank Post
    242
    Thanked 1,602 Times in 1,278 Posts
    Rep Power
    346

    Re: Excel Formula Help

    For future reference, an excellent website I have used in the past is mrexcel.com

    Like edugeek, it's free and my questions usually get answered in minutes. There are some real Excel boffins on there who really know their stuff

  5. #5

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    10,053
    Thank Post
    3,585
    Thanked 1,123 Times in 1,025 Posts
    Rep Power
    377

    Re: Excel Formula Help

    not sure if this is possible, just going from what was said above.

    But couldnt you click on the column A header so it arranges it by username alphabetically so

    username a
    username a
    username a
    username b
    username b
    etc
    etc

    and do a sumif on each repeated name so for all username a's it sums it and all username b's it sums it etc etc

    Unless im missing something ?



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 07:18 AM
  2. ICT Budget formula.
    By sLiDeR in forum Budgets and Expenditure
    Replies: 10
    Last Post: 23rd January 2008, 09:14 PM
  3. Time formula for hours and minutes
    By timbo343 in forum How do you do....it?
    Replies: 5
    Last Post: 1st October 2007, 06:55 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 05:19 PM
  5. RANDBETWEEN in MS Excel
    By woody in forum Educational Software
    Replies: 3
    Last Post: 14th February 2006, 02:34 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •