Try this then

=SUMIF(D:D,"department",I:I)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"David Cleland" <davidjcleland@hotmail.com> wrote in message
news:eEXVTR8ZGHA.4544@TK2MSFTNGP02.phx.gbl...
>
>
> >
> > If you are not familiar with Pivot Tables, see:
> >
> > http://peltiertech.com/Excel/Pivots/pivotstart.htm
> > --
> > Gary's Student
>
> flip, I am totally lost already, is there an easier way ?
>
> David
>
>