Remember Me?

#1
November 1st 04, 08:11 PM
 Liz G Posts: n/a
combining countif formulas

Hi,

One more question. I have a countif formula (see post: variation on
countif) that reads Countif(A1:A100, "*value*"). The situation users were
asked to list their past isp's and could list more than one in a cell. So,
is there a way to say "Count this cell if the cell includes 'aol', 'america
online', OR 'america on-line'"?

Liz

#2
November 1st 04, 08:28 PM
 Frank Kabel Posts: n/a

Hi
one way: just add the COUNTIF statements.
Another way:
=SUM(COUNTIF(A1:A100,{"*aol*","*America Online*","*america on-lin*"}))

--
Regards
Frank Kabel
Frankfurt, Germany

Liz G wrote:
Hi,

One more question. I have a countif formula (see post: variation on
countif) that reads Countif(A1:A100, "*value*"). The situation users
were asked to list their past isp's and could list more than one in a
cell. So, is there a way to say "Count this cell if the cell
includes 'aol', 'america online', OR 'america on-line'"?

Liz

#3
November 1st 04, 08:45 PM
 Liz G Posts: n/a

Thanks Frank,

The only thing is, I want to make sure that people who replied with
something like "america online (aol)" don't get counted twice. That's the
reason behind this question. Will your sum statement do that? Can I just
use the Countif statement inside the sum?

Thanks,
Liz

"Frank Kabel" wrote in message
...
Hi
one way: just add the COUNTIF statements.
Another way:
=SUM(COUNTIF(A1:A100,{"*aol*","*America Online*","*america on-lin*"}))

--
Regards
Frank Kabel
Frankfurt, Germany

Liz G wrote:
Hi,

One more question. I have a countif formula (see post: variation on
countif) that reads Countif(A1:A100, "*value*"). The situation users
were asked to list their past isp's and could list more than one in a
cell. So, is there a way to say "Count this cell if the cell
includes 'aol', 'america online', OR 'america on-line'"?

Liz

#4
November 1st 04, 09:34 PM
 Frank Kabel Posts: n/a

Hi
P.S.: no need for posting the question again

--
Regards
Frank Kabel
Frankfurt, Germany

Liz G wrote:
Thanks Frank,

The only thing is, I want to make sure that people who replied with
something like "america online (aol)" don't get counted twice.
That's the reason behind this question. Will your sum statement do
that? Can I just use the Countif statement inside the sum?

Thanks,
Liz

"Frank Kabel" wrote in message
...
Hi
one way: just add the COUNTIF statements.
Another way:
=SUM(COUNTIF(A1:A100,{"*aol*","*America Online*","*america
on-lin*"}))

--
Regards
Frank Kabel
Frankfurt, Germany

Liz G wrote:
Hi,

One more question. I have a countif formula (see post: variation

on
countif) that reads Countif(A1:A100, "*value*"). The situation
users were asked to list their past isp's and could list more than
one in a cell. So, is there a way to say "Count this cell if the
cell includes 'aol', 'america online', OR 'america on-line'"?

Liz

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JRH New Users to Excel 4 January 22nd 05 05:26 PM John Lovin Excel Discussion (Misc queries) 3 January 18th 05 10:50 PM John Excel Discussion (Misc queries) 0 January 12th 05 04:29 PM jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM Top Spin New Users to Excel 2 December 20th 04 04:54 PM

All times are GMT +1. The time now is 10:19 AM.

The comments are property of their posters.