Trouble with selecting multiple ranges of data

I'm using the countif function and I need some help.
I have several rows of data but I don't want to use them all.
I have a problem though, because I can't arrange the data so
the rows I want are all together.
Lets say my data starts in row 1 and ends in row 6,
I only want rows 2, 4, & 6. I have tried holding ctrl and selecting
just those rows, but it separates the ranges with commas and I think that is
what is messing up the function. COUNTIF separates its data from the
criteria using a comma. I tried placing ( ) around my data but that didn't
work either.
Can someone help please.
The function I am using is the array function:
=MAX(IF(COUNTIF(Rannge, Range) > 0, Range))

=MAX(IF(MOD(ROW(A1:A6),2)=0,A1:A6))

perhaps

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"markag" <[email protected]> wrote in message
news:[email protected]...
> I'm using the countif function and I need some help.
> I have several rows of data but I don't want to use them all.
> I have a problem though, because I can't arrange the data so
> the rows I want are all together.
> Lets say my data starts in row 1 and ends in row 6,
> I only want rows 2, 4, & 6. I have tried holding ctrl and selecting
> just those rows, but it separates the ranges with commas and I think that
is
> what is messing up the function. COUNTIF separates its data from the
> criteria using a comma. I tried placing ( ) around my data but that
didn't
> work either.
> Can someone help please.
> The function I am using is the array function:
> =MAX(IF(COUNTIF(Rannge, Range) > 0, Range))

I don't konw if that is going to work or not

my data looks something like this

* 5 4 8 1 9 5 1 5 3 1 8 5
1 1 8 3 1 4 8 5 3 1 1 1
2 5 4 3 5 1 6 8 4 9 1 1
* 4 5 4 4 8 3 1 6 7 6 4 8
1 1 8 3 1 4 8 5 3 1 1 1
2 5 4 3 5 1 6 8 4 9 1 1

I only can use the rows with the * next to them. The other data pertains to
something else. I need to select the entire row for each needed row to make
up my range. My function that I've been using works fine for what I need to
calculate, I just don't know how to make it work with the way my data is
arranged.


"Bob Phillips" wrote:

> =MAX(IF(MOD(ROW(A1:A6),2)=0,A1:A6))
>
> perhaps
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "markag" <[email protected]> wrote in message
> news:[email protected]...
> > I'm using the countif function and I need some help.
> > I have several rows of data but I don't want to use them all.
> > I have a problem though, because I can't arrange the data so
> > the rows I want are all together.
> > Lets say my data starts in row 1 and ends in row 6,
> > I only want rows 2, 4, & 6. I have tried holding ctrl and selecting
> > just those rows, but it separates the ranges with commas and I think that
> is
> > what is messing up the function. COUNTIF separates its data from the
> > criteria using a comma. I tried placing ( ) around my data but that
> didn't
> > work either.
> > Can someone help please.
> > The function I am using is the array function:
> > =MAX(IF(COUNTIF(Rannge, Range) > 0, Range))
>
>
>