I am trying to create a formula and having great difficulty. I have a spreasheet with employee absence recorded on it.
I need to create a formula that will look down one column to find a particular employee code and then look down another column to find an absence type and sum a different another column where these two conditions are matched.
I initially thought a SUMIF function would work but cannot use multiple conditions.
Can anybody help me please?