I meant also to point you to the Help file to learn about Pivot Tables
Bernard

"Lee Harris" wrote in message
...
I'm using a formula

=SUMIF(C:D,H2,D:D)


which sums salaries in column D if the company name listed in column C
matches the one listed in H (autofilled down a list of unique
organisations)


If column B contains a sub department of the organisation, is it possible
to do a SUMIF that will add up the salaries in D column for all data rows
where the organisation = such and such AND the department = SUCH and SUCH
(both organisation and department would be referenced by the content of
cells in column H2:H20 for organisation and I1:P1 for departments)


tks in advance