Could the "Criteria" in COUNTIF function be a cell reference?

N Harkawat · 09-05-2005, 10:05 PM

yes
=countif(a1:a100,B1)

"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>

Don Guillett · 09-05-2005, 10:05 PM

Norman was kind to answer your question. However, is there some reason you
couldn't have TRIED it first?

--
Don Guillett
SalesAid Software
[email protected]
"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>

N Harkawat · 09-05-2005, 11:05 PM

yes
=countif(a1:a100,B1)

"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>

Don Guillett · 09-05-2005, 11:05 PM

Norman was kind to answer your question. However, is there some reason you
couldn't have TRIED it first?

--
Don Guillett
SalesAid Software
[email protected]
"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>

JohnSheenWSN · 09-06-2005, 04:05 AM

N Harkawat · 09-06-2005, 04:05 AM

yes
=countif(a1:a100,B1)

"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>

Don Guillett · 09-06-2005, 04:05 AM

Norman was kind to answer your question. However, is there some reason you
couldn't have TRIED it first?

--
Don Guillett
SalesAid Software
[email protected]
"JohnSheenWSN" <[email protected]> wrote in message
news:[email protected]...
>