Use Excel's filtering capability to extract all records for new-car loans. How many individuals with new-car loans are single, married, and divorced? Complete the table below with the missing values

How do you work out the single count, married count and divorced count. Please show the formula and working out thanks

A B D E F G H Checkin Saving 392 Months Custome 19 0 Credit Ris High High 349 13 621 974 2921 4751 40 Low 0 11 Low 1 Loan Purpose 4 New Car 5 Furniture 6 Education 7 Furniture 8 New Car 9 Business 10 Small Appliance 11 Small Appliance 12 Business 0 13 Low 0 235 532 495 14 Low 6541 37 985 0 25 0 High High High Low 955 Months Employed Marital Statu 119 Single 14 Single 45 Single 13 Married 16 Married 2 Single 9 Single 4 Divorced o Single 15 Single 14 Married 63 Single 26 Single 8 Divorced 4 Divorced 33 Single 116 Single 2 Divorced 49 Job Management Unskilled Skilled Skilled Unskilled Unskilled Skilled Skilled Management Unskilled Skilled Skilled Unskilled Management Skilled Skilled Skilled Skilled 13 New Car 0 11 332 10 3393 583 821 237 0 25 13 403 Low High Low Low High Low 0 125 14 Business 15 New Car 16 New Car 17 Used Car 18 Furniture 19 New Car 20 Repairs 21 Education 31 49 733 692 13 676 703 202 287 0 28 Low 12325 7 High Marital Status Single count Married count Divorced count Loan Purpose New Car Savings 392 Single New Car 235 Married New Car 3,393 Single New Car 821 Single New Car 237 Single New Car 692 Single (Type whole numbers.)