| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you sum the amount of type a word appears?
Trying to sum the about of type a risk is open....So i need a statement to say
=SumIF(A1;A6=open,dont count)??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you sum the amount of type a word appears?
Sorted it - should have used Count If
=COUNTIF(B16:B4000,"*Open") "Scott_goddard" wrote: Trying to sum the about of type a risk is open....So i need a statement to say =SumIF(A1;A6=open,dont count)??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you sum the amount of type a word appears?
Use the countif function. countif(a1:a6,"open")
"Scott_goddard" wrote: Trying to sum the about of type a risk is open....So i need a statement to say =SumIF(A1;A6=open,dont count)??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose amount appears at first coloums | Excel Worksheet Functions | |||
| count the amount of times a two letters appears in text string | Excel Discussion (Misc queries) | |||
| Sum the amount of times a number appears in a column in Excel? | Excel Worksheet Functions | |||
| The number I type in a cell, e.g. 500, appears at 0.5 - why? | Excel Discussion (Misc queries) | |||
| When I type in 100 a 1 appears, 10000 and 100 appear | Excel Discussion (Misc queries) | |||
Linear Mode
