Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
Range is b3:af3 I want to total entries that would have s=2 in a cell or s=5
in the range. I cannot get the formula to work .. Any suggestions |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
maybe...
=countif(b3:af3,"s=2") or =countif(b3:af3,"*"&"s=2"&"*") if s=2 can be in a cell with other text. Rick wrote: Range is b3:af3 I want to total entries that would have s=2 in a cell or s=5 in the range. I cannot get the formula to work .. Any suggestions -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
Rick,
You need to clarify this (well for me you do). What precisely is in these cells, is it a text string s=5 etc or something else? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rick" wrote: Range is b3:af3 I want to total entries that would have s=2 in a cell or s=5 in the range. I cannot get the formula to work .. Any suggestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |