Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
confused
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
confused
.. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Now I'm Really Confused | New Users to Excel | |||
I'm still confused | Excel Worksheet Functions | |||
Confused | Excel Worksheet Functions | |||
Very confused.... | Excel Discussion (Misc queries) | |||
confused,please help | Excel Discussion (Misc queries) |