Prev: Making a structured reference absolute?
Next: Already exists on the destination workbook
From: Stefi on 30 May 2008 03:22
You are welcome! Thanks for the feedback!
Stefi

„goayimm” ezt írta:

> YAY it works!
> thanks
>
> =)
>
> "Stefi" wrote:
>
> > =SUMPRODUCT(--(A1:A6="X"),--(B1:B6=1))
> > Warning! You have to adjust ranges to your real needs! In Excel 2003 you
> > can't refer to entire columns (like A:A)! (In excel 2007 yes!)
> >
> > Regards,
> > Stefi
> >
> >
> > „goayimm” ezt írta:
> >
> > > HI,
> > >
> > > say I have table like this:
> > >
> > > A B
> > > X 1
> > > X 1
> > > X 0
> > > X 1
> > > 1
> > > X 0
> > >
> > > so, i would like to count all that that fulfill X in column A and 1 in
> > > column B.
> > > the answer should be 3.
> > >
> > > Thanks.
> > >
> > >
> > > "Stefi" wrote:
> > >
> > > > =SUMPRODUCT(--(criterium for A),--(criterium for B))
> > > > Give more details on criteria if you don't succeed!
> > > >
> > > > Regards,
> > > > Stefi
> > > >
> > > > „goayimm” ezt írta:
> > > >
> > > > > Hi,
> > > > >
> > > > > if I have 2 lines of data say, A and B.
> > > > >
> > > > > I need to count num of data that fulfill both X criteria in A row and Y
> > > > > criteria in B row.
> > > > >
> > > > > How do I do that?
> > > > >
> > > > > Thanks.
> > > > >
> > > > >
First  |  Prev  | 
Pages: 1 2
Prev: Making a structured reference absolute?
Next: Already exists on the destination workbook