CountIF
 

=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

In general, each would have to be handled separately, but if the intervening
cells would not contain an X, then you wouldn't need to exclude them to get
the count.

=Countif(A3:A6,"X")+Countif(A9:A12,"X")+Countif(A1 5:A18,"X")

--
Regards,
Tom Ogilvy


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

=COUNTIF(A3:A6,"X")+COUNTIF(A9:A12,"X")+COUNTIF(A1 5:A18,"X")



"Arturo" wrote:

=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

If they are structured as you show, you can use

=SUMPRODUCT(--(A3:A18="X"),--(MOD(INT(ROW(A3:A18)/3),2)=1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

That would work if the pattern were A3:A5,A9:A11,A15:A17, but unfortunately
it wasn't.

such as A3:A6,A9:A12,A15:A18?

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
If they are structured as you show, you can use

=SUMPRODUCT(--(A3:A18="X"),--(MOD(INT(ROW(A3:A18)/3),2)=1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

A B C
1 S6 B2

I know how to use the countif function as if to count all values that equal
"S*" (value beginning with "S" only regardless of the following number) in a
row. Then tally, per row, the number of times "S*" appeared in the range.
The formula for "C1" would be: =countif(A1:B2,"S*") which right now would
return the value of 1. Now what I want to do is in addition to this formula,
I want "C1" to also calculate the countif portion and then multiply the
countif returned value by the second number in the stated cell. i.e. A1 =
S6, so "C1" has a value of "1", now mulitply the "1" by the second digit in
"A1" (which is 6). How would I go about this? Thanks.

Gee-off


"Tom Ogilvy" wrote:

In general, each would have to be handled separately, but if the intervening
cells would not contain an X, then you wouldn't need to exclude them to get
the count.

=Countif(A3:A6,"X")+Countif(A9:A12,"X")+Countif(A1 5:A18,"X")

--
Regards,
Tom Ogilvy


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo

CountIF
 

See response in .worksheet.functions

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gee-off" wrote in message
...
A B C
1 S6 B2

I know how to use the countif function as if to count all values that
equal
"S*" (value beginning with "S" only regardless of the following number) in
a
row. Then tally, per row, the number of times "S*" appeared in the range.
The formula for "C1" would be: =countif(A1:B2,"S*") which right now
would
return the value of 1. Now what I want to do is in addition to this
formula,
I want "C1" to also calculate the countif portion and then multiply the
countif returned value by the second number in the stated cell. i.e. A1
=
S6, so "C1" has a value of "1", now mulitply the "1" by the second digit
in
"A1" (which is 6). How would I go about this? Thanks.

Gee-off


"Tom Ogilvy" wrote:

In general, each would have to be handled separately, but if the
intervening
cells would not contain an X, then you wouldn't need to exclude them to
get
the count.

=Countif(A3:A6,"X")+Countif(A9:A12,"X")+Countif(A1 5:A18,"X")

--
Regards,
Tom Ogilvy


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that
formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo