IFS and COUNTIFS

I am looking to know how many of these ID have used 1 or more benefits. The column C should say the total benefits used i.e. between 1-5, NOT the total count of each benefit.

0113514 Taxable Parking
0113514 Taxable Parking
0113514 Personal Cell Subsidy
0113514 Taxable Parking
0122724 Personal Cell Subsidy
0122724 Personal Cell Subsidy
0122724 Taxable Parking
0122724 Personal Cell Subsidy
0122724 Taxable Parking
0136372 Auto Allowance- Taxable

By: OSHIN

Leave a Reply

Your email address will not be published. Required fields are marked *