|
Re: Help with VB code
Well, it works, which is better than what I did, also, Ranking Points are divided by 3 for their final score, and finally, your IF satements in the totals columns seem kind of pointless, could you please specify what they are for?
~Nick/1334
EDIT: The statement in the last column should actually be
=IF(ISERROR(SUMIF($C$2:$GT$2,"RP",C3:GT3)/(COUNT(C3:GT3)/2)),0,SUMIF($C$2:$GT$2,"RP",C3:GT3)/(COUNT(C3:GT3)/4))/3
__________________
2008 : GTA Regional 7th Seed, Quarters
2008 : Waterloo Regional 4th Seed, Quarters
2007 : GTA Regional 2nd Seed, Quarters
2007 : Waterloo Regional Quarters
Last edited by Setsanto : 02-02-2007 at 16:27.
|