Combine Rows

**nabberuk** · 12-13-2007, 02:10 PM

I'm pretty rubbish at excel but wondered if anyone could give us a hand.

I've a list of pages printed on a single printer, in the format of;

user 1
user 3
user2 5
user2 6

So each print job makes a row with their username and how many pages they've printed. Now as the user's have printed more than once, i would like to add all these up. So in the above example it would turn into;

user 4
user2 11

I have about 2500 rows of all different users. so is there a function/sum/whatever i can do to work this out quicky?

many thanks

**Norie** · 12-13-2007, 02:40 PM

Take a look at Data>Pivot Table...

**Paul** · 12-13-2007, 11:34 PM

Pivot Tables would most certainly handle this situation, especially if your data is laid out nicely and you know how pivot tables work.

Another option might be to use a SUMIF formula. For example, if column A contains all of your users (including duplicates) and column B contains totals of all of their print jobs as in your example, you could use something like:

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

Or if you had a listing of all the individual users in column E1:E20, in F1 you could put

=SUMIF(A:A,E1,B:B)

and then simply drag that formula down to your last user in column E.

Try both options and use what makes more sense for you!

Combine Rows

LinkBack

Thread Tools

Rate This Thread

Display

Combine Rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions