Complex function

Hi all,

I'm trying to do a function within Excel. I don't know if it's possible, buut...

I have attatched a JPG screenshot of a sample excel sheet. If you would like to download the actual excel sheet, click HERE.

In the "Pages" column, I want a function that calculates, basically, the number of pages that the user has printed. This will mean searching for each instance of the user's name under column A, and then adding the respective page count from the "Pages" column ©.

In this example A, the function should see that there is user A in line 5, 8, 12, 17, 25, and 27. It should add the respective values of 12, 65, 21, 232, 23, and 5. The value appearing in the "Pages" box under "Totals" should then be 358 (All of those page totals together). This should be one function under that cell (L4)

Does this make sense? Is it possible?

Thanks,
Arby.

Perfect, thank you

Another thing,

In the Columns D,E,F, and G (Black? Cyan? Magenta? Yellow?) there will be the word "Yes" or "No". what function can I put in M4 for example Black jobs total for A) that will let me count all of the "YES"s in the "Black" column for the user "A"?

Basically I want to count up how many jobs by a given user have a yes in a given colour, and add up the totals.

Works great, thanks