Re: COUNT IF.... Feature, please help ASAP
- From: "Ragdyer" <RagDyer@xxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 20:51:39 -0700
Post your formula, and the ranges you're using, together with their content.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Count If" <CountIf@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD654BD4-9C2D-4E6A-95A6-71C5A5A32AF7@xxxxxxxxxxxxxxxx
> Thanks a bunch. I was so excited to get a response.
>
> Me and my boss are trying this, but we are off by 1 on every example we've
> tried.
>
> Any suggestions?
>
> "Govind" wrote:
>
> > Hi,
> >
> > Use
> >
> > =SUMPRODUCT(($A$2:$A$7="X")*(C2:C7="Y"))
> >
> > Regards
> >
> > Govind.
> >
> > Count If wrote:
> > > Does anyone out there know if it is possible to have the count if
feature can
> > > retrieve and count data from more than column, ie; I want it to count
all of
> > > my X data in column A and then out of all of those X's in column, how
many of
> > > those belong to Y in column C. Thanks greatly appreciated, this is
for a
> > > major spreadhseet I'm producing for work and I want to impress my
boss. BR
> >
.
- References:
- COUNT IF.... Feature, please help ASAP
- From: Count If
- Re: COUNT IF.... Feature, please help ASAP
- From: Govind
- Re: COUNT IF.... Feature, please help ASAP
- From: Count If
- COUNT IF.... Feature, please help ASAP
- Prev by Date: REALLY miussing rows in Excel2000
- Next by Date: Re: Like match between 2 ranges
- Previous by thread: Re: COUNT IF.... Feature, please help ASAP
- Next by thread: Re: no show all function in dropdown list in Pivot Table
- Index(es):
Relevant Pages
|
