Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Does a description exist in a book or website of valid countif criteria?
For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Have you tried
=COUNTIF(A$7:A$15,1+1) -- Don Guillett SalesAid Software "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
The second argument in COUNTIF is not a formula, but a criteria. So you can
build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Bob & Don:
First, thank you both very much for taking the time to help me. Second, where would you suggest is a good place to find out about this stuff. Your responses helped me, but Excel Help did not. People keep telling me "everybody knows" "everybody knows" that wildcards work with countif, but not the substitute function. "everybody knows" that sum works across completely separate cells, but sumif does not. Can you recommend a book that I can study that will tell me "what everybody knows" but me? -- jake "Bob Phillips" wrote: The second argument in COUNTIF is not a formula, but a criteria. So you can build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Not really, because not everybody knows, and we all know something
different. Just watch this group, reading the posts and the responses, you will learn a lot. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Bob & Don: First, thank you both very much for taking the time to help me. Second, where would you suggest is a good place to find out about this stuff. Your responses helped me, but Excel Help did not. People keep telling me "everybody knows" "everybody knows" that wildcards work with countif, but not the substitute function. "everybody knows" that sum works across completely separate cells, but sumif does not. Can you recommend a book that I can study that will tell me "what everybody knows" but me? -- jake "Bob Phillips" wrote: The second argument in COUNTIF is not a formula, but a criteria. So you can build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
I believe what you're looking for can be labeled "experience", for, as you
realize, there are just too many fuzzy questions to be answered in any one, single place. I've suggested this to others, and they've acknowledged that it was a "good" start: http://tinyurl.com/2bah9v -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jakobshavn Isbrae" wrote in message ... Bob & Don: First, thank you both very much for taking the time to help me. Second, where would you suggest is a good place to find out about this stuff. Your responses helped me, but Excel Help did not. People keep telling me "everybody knows" "everybody knows" that wildcards work with countif, but not the substitute function. "everybody knows" that sum works across completely separate cells, but sumif does not. Can you recommend a book that I can study that will tell me "what everybody knows" but me? -- jake "Bob Phillips" wrote: The second argument in COUNTIF is not a formula, but a criteria. So you can build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Thanks, I will take your advice and put frustration aside,
-- jake "Bob Phillips" wrote: Not really, because not everybody knows, and we all know something different. Just watch this group, reading the posts and the responses, you will learn a lot. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Bob & Don: First, thank you both very much for taking the time to help me. Second, where would you suggest is a good place to find out about this stuff. Your responses helped me, but Excel Help did not. People keep telling me "everybody knows" "everybody knows" that wildcards work with countif, but not the substitute function. "everybody knows" that sum works across completely separate cells, but sumif does not. Can you recommend a book that I can study that will tell me "what everybody knows" but me? -- jake "Bob Phillips" wrote: The second argument in COUNTIF is not a formula, but a criteria. So you can build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
description of countif criteria?
Thank you. You have pointed me to a near library of information.
I'll start reading. -- jake "Ragdyer" wrote: I believe what you're looking for can be labeled "experience", for, as you realize, there are just too many fuzzy questions to be answered in any one, single place. I've suggested this to others, and they've acknowledged that it was a "good" start: http://tinyurl.com/2bah9v -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jakobshavn Isbrae" wrote in message ... Bob & Don: First, thank you both very much for taking the time to help me. Second, where would you suggest is a good place to find out about this stuff. Your responses helped me, but Excel Help did not. People keep telling me "everybody knows" "everybody knows" that wildcards work with countif, but not the substitute function. "everybody knows" that sum works across completely separate cells, but sumif does not. Can you recommend a book that I can study that will tell me "what everybody knows" but me? -- jake "Bob Phillips" wrote: The second argument in COUNTIF is not a formula, but a criteria. So you can build an expression like the one you gave =COUNTIF(A$7:A$15,"="&1+1) but you cannot pass it directly. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jakobshavn Isbrae" wrote in message ... Does a description exist in a book or website of valid countif criteria? For example - =COUNTIF(A$7:A$15,2) works =COUNTIF(A$7:A$15,"=2") also works, but =COUNTIF(A$7:A$15,"=1+1") does not work I don't need an answer to a specific example, just a place to go and read on my own. Thanks in advance for any help received. -- jake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two criteria for CountIf? | Excel Worksheet Functions | |||
More than 1 countif criteria | Excel Discussion (Misc queries) | |||
can countif function look at 2 separate columns for criteria | Excel Worksheet Functions | |||
COUNTIF with two criteria | Excel Worksheet Functions | |||
Countif with star operator in criteria | Excel Worksheet Functions |