Wouldn't it be easier if you make a pivot table?

Charles wrote:
Hi Everyone,

I have one more question about totalling to multiple groups. As I posted in
the following, I want to total credit hours for full time (F Total) and part
time (P Total) faculty within each department:

Department Faculty Credit
ANTHROPOLOGY F Total 76
ANTHROPOLOGY P Total 37
ART F Total 87
ART P Total 24
ART F Total 77
ART P Total 63
BIOLOGICAL SCIENCES F Total 32
BIOLOGICAL SCIENCES P Total 12
BIOLOGICAL SCIENCES F Total 76

I want to get the results like

Department Faculty Credit FCredit
PCredit
ANTHROPOLOGY F Total 76 76 37
ANTHROPOLOGY P Total 37
ART F Total 87 164 87
ART P Total 24
ART F Total 77
ART P Total 63
BIOLOGICAL SCIENCES F Total 32 108 12
BIOLOGICAL SCIENCES P Total 12
BIOLOGICAL SCIENCES F Total 76

It seems complex. Who can help me figure out the codes for this purpose? I
will very appreciate your help. Thanks.

Charles

--
Message posted via http://www.officekb.com