| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to calculate simple formula for cells
I have a spreadsheet that uses columns A - Z, in some of the cells up
to here, I have the word 'yes'. I need to know how to calculate the number of 'yeses' in the cells to come up with how many I have. How do I do it? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to calculate simple formula for cells
=COUNTIF(Range,"Yes")
replace Range with the cell references needed -- Regards, Peo Sjoblom "victoriaawatson" wrote in message oups.com... I have a spreadsheet that uses columns A - Z, in some of the cells up to here, I have the word 'yes'. I need to know how to calculate the number of 'yeses' in the cells to come up with how many I have. How do I do it? Thanks |
|
#3
|
|||
|
|||
|
=COUNTIF(A:Z,"yes")
this is case insensitive. Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a simple formula for a range of cells | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| Most simple formula to calculate date+ 30 months? | Excel Worksheet Functions | |||
| simple formula with blank cells | Excel Worksheet Functions | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
Linear Mode
