| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating Percentages in a Range
How do I set up an Excel formula that calculates the percentage of "Y"
entries in a range of cells that contains both "Y" and "N" entries? |
|
#2
|
|||
|
|||
|
if there are no rersponse answers in the range
try =sumif(range,"Y")/(sumif(range,"Y")+sumif(range,"N") If there are only Ys or Ns in the range =sumif(range,"Y")/counta(range) "Allen7575" wrote: How do I set up an Excel formula that calculates the percentage of "Y" entries in a range of cells that contains both "Y" and "N" entries? |
|
#3
|
|||
|
|||
|
maybe countif() instead of sumif()??
"bj" wrote: if there are no rersponse answers in the range try =sumif(range,"Y")/(sumif(range,"Y")+sumif(range,"N") If there are only Ys or Ns in the range =sumif(range,"Y")/counta(range) "Allen7575" wrote: How do I set up an Excel formula that calculates the percentage of "Y" entries in a range of cells that contains both "Y" and "N" entries? |
|
#4
|
|||
|
|||
|
I agree. I got sloppy
"Duke Carey" wrote: maybe countif() instead of sumif()?? "bj" wrote: if there are no rersponse answers in the range try =sumif(range,"Y")/(sumif(range,"Y")+sumif(range,"N") If there are only Ys or Ns in the range =sumif(range,"Y")/counta(range) "Allen7575" wrote: How do I set up an Excel formula that calculates the percentage of "Y" entries in a range of cells that contains both "Y" and "N" entries? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Calculating Percentages with Variables | Excel Worksheet Functions | |||
| Calculating percentages | Excel Worksheet Functions | |||
Linear Mode
