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" wrote in message
...
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" wrote in message
...
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))