Question for creating a league table

[joncurtis199]

Hi I've began to setup a system in a tournament where when I update my
results sheet the table updates as well.

http://img301.imageshack.us/img301/6445/excel8yl.jpg

On here I want to know how I could get J2 to add up all the "L"s in
D2:I2. Would I use DCOUNTA for this and what would I use for database
and field?

 

[Anne Troy]

=countif(d2:i2,"L")
*******************
~Anne Troy

www.OfficeArticles.com


"joncurtis199" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

You might want to take a look at
http://xldynamic.com/source/xld.LeagueTable.html

--
HTH

Bob Phillips

"joncurtis199" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

If you need to set up the table to automatically sort the table you can look