Also, you may want to take a look at pivot tables which allow real easy
analysis of this stuff.
http://www.geocities.com/jonpeltier/...pivotstart.htm
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"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