Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I count non-contiguous cells?
3,667 views
Skip to first unread message
broush
May 30, 2006, 11:43:01 AM5/30/06
to
I am trying to use the countif function to add non-contigous cells but I am
getting an error. I want to count 4 cells on a sheet that have a value
greater than 0.
getting an error. I want to count 4 cells on a sheet that have a value
greater than 0.
Gary''s Student
May 30, 2006, 11:54:01 AM5/30/06
to
COUNTIF() doesn't work on disjoint ranges. The usual approach is to use
several COUNTIF()'s and add them up.
--
Gary's Student
several COUNTIF()'s and add them up.
--
Gary's Student
CLR
May 30, 2006, 12:36:01 PM5/30/06
to
Assign a RangeName to your non-contiguious range and try this......
=COUNT(YourRangeName)
Vaya con Dios,
Chuck, CABGx3
Bob Phillips
May 30, 2006, 12:35:17 PM5/30/06
to
=SUMPRODUCT(COUNTIF(INDIRECT({"A2","B7","H9","I1"}),">0"))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"broush" <bro...@discussions.microsoft.com> wrote in message
news:C8D92B6E-80F4-41E4...@microsoft.com...
broush
May 30, 2006, 12:37:02 PM5/30/06
to
Thanks for the help!
Domenic
May 30, 2006, 6:16:43 PM5/30/06
to
Here's another way...
=INDEX(FREQUENCY((A2,B7,H9,I1),0),2)
Hope this helps!
In article <C8D92B6E-80F4-41E4...@microsoft.com>,
0 new messages