| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average letters
hiya guys, I need some help. in my worksheet cells B1 to B13 contain either an "r" or a "g" i need cell b14 to display an "g" if 75% of the cells B1:B13 contain a "g" if not it should display an "R". I am a noob and have no idea how to do this but have to get it done for work 2moro!!! Cheers James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=491944 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average letters
Countif can tell you how many cells in a range meet a certain condition. So
you could do something like =if(countif(b1:b13,"g")=3*countif(b1:b13,"r"),"g" ,"r") "superkopite" wrote: hiya guys, I need some help. in my worksheet cells B1 to B13 contain either an "r" or a "g" i need cell b14 to display an "g" if 75% of the cells B1:B13 contain a "g" if not it should display an "R". I am a noob and have no idea how to do this but have to get it done for work 2moro!!! Cheers James -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=491944 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average letters
Thanks alot that worked a treat. -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=491944 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Average Formula with Criteria | Excel Discussion (Misc queries) | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Hybrid Mode
