I have a wages spreadsheet (sample attached) which has columns for Employee ID, quarter in which wages were earned and wages earned
I have a summary table below the date intoi which I wish to sum the total wages for a selected employee in a particular quarter.
My underrstanding of thye problem is that I wouyld need to index the wages , match the employee id in the sumary table AND the quarter in the summary table to total the employee's wages in each quarter.
I am using ther formula
I have a summary table below the date intoi which I wish to sum the total wages for a selected employee in a particular quarter.
My underrstanding of thye problem is that I wouyld need to index the wages , match the employee id in the sumary table AND the quarter in the summary table to total the employee's wages in each quarter.
I am using ther formula
=IF(ISBLANK($A27),0,IFERROR(INDEX($C$4:$C$16,MATCH($A27,$A$4:$A$16,0)),"")) but that not only does NOT correctly sum each employee for Quarter 1 but fails to sum Q2,3,and 4. The atached sample shows the Employee ID (column A), Earniong Quarter (Column B) and wages (Column C). Below that data is an incorrect summary table and a table showing my expected values. Any help is solving this? Thanks. |