0


I have a list of data in .xlsx The data is in column W

the data includes 1. ACCEPTABLE 2. UNACCEPTABLE

I want to count the number of ACCEPTABLE and total of both ( ACC and UNACC ) and the formula would be

ACCEPTABLE divide by number of ACCEPTABLE + UNACCEPTABLE * 100

I want the data to be shown at the last row of COLUMN W

The data layout would be same...