SUMIF with two conditions?
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
|