Excel Formula Help

[DSapseid]

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

[Iain]

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

 

=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.

[DSapseid]

Thanks Iain that works a treat. 8)

[Michael]

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

[mac_shinobi]

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 ?