Upload the file to http://www.savefile.com/

You will get a URL from that.

Post the URL back here so anyone can download the file.


Gord Dibben MS Excel MVP

On Mon, 20 Oct 2008 12:07:16 -0700, Lisa L
wrote:

No - I want to count the number of losses each participant has in each row.
I'm sorry it's very difficult to explain. Is there anyway I can show you the
spreadsheet?

"Rick Rothstein" wrote:

So you actually want to count the number of cells in a column that contains
the winning team's name then, right? Assuming the Patriots won and that
Column A has the team names in it (Rows 2 to at least 200), then try this
formula...

=COUNTIF(A2:A200,"Patriots")

--
Rick (MVP - Excel)


"Lisa L" wrote in message
...
I did not manually type a conditional function - I used the "conditional
formatting" button under the home/styles tab. I don't know how to write
out
a conditional format.

Let me try to explain my worksheet a little better. It's a chart for a
football pool. Each row has a participants' picks for each game going
across
the columns. So each column counts for one game that could have two
possible
outcomes. I.e. - The Broncos are playing the Patriots so the column will
have
one of the two teams whichever the participant picks to win. Once all the
games are played - I used to have to go through each column and select all
the losing teams and right click - format cell and change the formatting
to
gray out the cells so they become losses. Then I discovered "conditional
formatting" which is pretty much error proof. So now I am able to select
the
column and type in the losing team and it automatically formats the entire
column for me. Once all the losing teams have been filled gray and I have
to
manually count the ungrayed cells in each row. These count as wins. This
was easy when we only had 20 people playing but now there are 95 and i'm
afraid i'm going to make an error.

I'm sure it would be so much easier if you were able to see the worksheet
but any help you can provide would be much appreciated.





"David Biddulph" wrote:

Use COUNTIF or SUMPRODUCT, and use the same condition you've used in your
conditional formatting.
--
David Biddulph

"Lisa L" <Lisa wrote in message
...
I have a worksheet in which i have used conditional formatting to gray
out
certain values in a column. There are approximately 10 columns across
all
with conditional formatting. Is anyone aware of a way to "count" the
number
of cells in each row that are not grayed out?