# Excel Formula Help

Printable View

• 7th November 2007, 10:28 AM
DSapseid
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
• 7th November 2007, 10:48 AM
Iain
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.
• 7th November 2007, 10:55 AM
DSapseid
Re: Excel Formula Help
Thanks Iain that works a treat. 8)
• 7th November 2007, 04:24 PM
Michael
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 :)
• 7th November 2007, 04:56 PM
mac_shinobi
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 ?