ExcelBanter - confused

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - confused (https://www.excelbanter.com/excel-worksheet-functions/238430-confused.html)

I have a spreadsheet with several rows with a letter in each cell. I'm
looking for a formula that will add up the number of cells in the row with
certain letters in them, and divide that by the total number of cells in the
row that have a letter in them. I'm looking for the percentage, to be
specific, of cells that only have a P,T,L,TL, in the row, from the cells that
have a P,T,L,TL,A,U. It's a little too above me.

.. looking for the percentage, to be specific,
of cells that only have a P,T,L,TL, in the row,
from the cells that have a P,T,L,TL,A,U

Assume your source data to be checked is in say A2:K2 down,
place in L2:
=SUMPRODUCT(--ISNUMBER(MATCH(A2:K2,{"P","T","L","TL"},0)))/
SUMPRODUCT(--ISNUMBER(MATCH(A2:K2,{"P","T","L","TL","A","U"},0) ))
Format L2 as percentage, copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"mdj0615" wrote:
I have a spreadsheet with several rows with a letter in each cell. I'm
looking for a formula that will add up the number of cells in the row with
certain letters in them, and divide that by the total number of cells in the
row that have a letter in them. I'm looking for the percentage, to be
specific, of cells that only have a P,T,L,TL, in the row, from the cells that
have a P,T,L,TL,A,U. It's a little too above me.