Expanding a Formula

[Excel_77]

Hi All,

I have setup the below formula to return the count of people for each category.

=SUMIFS('MASTER TAB'!IY:IY,'MASTER TAB'!IW:IW,"Employee",'MASTER TAB'!IX:IX,"£0 to £10k")

IY is a column within the master tab which has a default value of "1" for each employee.

IW is a field within the master tab, the criteria here needs to be met and it needs to = "employee".

IX is the final criteria in master tab that needs to be met and this needs to = "£0 to £10k".

The above works fine, however I need to expand this criteria to find the net pay in Master tab (AA) and return this as a percentage of gross salary in Master tab (AB), what is the formula for this? The original criteria of "employee" and "£0 to £10k"still needs to be met.

Thanks in advance

 

[Joe4]

You should be able to use similar formulas. Just, instead of return the "IY" column, return the "AA" or "AB" column.
Each one will be its own formula.

By the way, in your original formula, if the sole purpose of the IY formula is to get the total count with the formula, then that column isn't really needed at all. You can just use a COUNTIFS with your two conditions.