Function within Excel

[Arbital24]

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.

EDIT: Nevermind, I got a reply at another forum.

In case anyone in interested, the solution:

Hi,

In L4 =SUMIF($A$5:$A$27,"="&J4,$C$5:$C$27)

or more simply

=SUMIF($A$5:$A$27,"=A",$C$5:$C$27)

Edited May 30, 2007 by Arbital24

[IcemanND]

that or create a pivot table