Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
SUMIF - 2 conditions - with references | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Discussion (Misc queries) | |||
sumif with two conditions | Excel Worksheet Functions | |||
SUMIF based on 2 conditions | Excel Worksheet Functions |