IF and COINTIF functions

[Bill Matt]

I am keeping the standings for a youth b-ball league with 14 divisions. When I post the scores on the master schedule, I want the standing automatically updated. I created a seperate worksheet for each division, but do not know how to link the results from the master schedule to each division.

 

[xapie128]

I don't know if I follow what you want to do, but if I understand correctly you simply want to enter data in one worksheet and have it also appear in another.

If so, just select the cell where you want the data to appear, press the equal key (=), select the other worksheet tab and select the cell where you will be entering the data, then press the Enter key.

 

[Brian from Maui]

See,

http://www.mrexcel.com/board2/viewtopic.php?t=49840