Assuming the first cell is A1
Then in D2
=IF($A1<$A2,SUMPRODUCT(--($A$2:$A$10=$A2),--($B$2:$B$10="F
Total"),$C$2:$C$10),"")
In E2
=IF($A1<$A2,SUMPRODUCT(--($A$2:$A$10=$A2),--($B$2:$B$10="P
Total"),$C$2:$C$10),"")

"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