Setting up a standings sheet for a 6 team league that uses head to head matchups, and in my very limited knowledge of Excel formulas, have the following formula sitting in a cell of the 'Ties' column. Is there a formula that is much shorter to use for this purpose? Also, seeing as the data for this formula is 2 rows of empty cells, it has filled the cell with the value of 9. i wish for the cell to display 0 or the cumulative tally of any 'real' ties from this point going forward (seeing as the data has not occurred yet, there may be no ties at all at seasons end, resulting in a 0 sum anyways. How do i get this formula to ignore empty cells? Using =if(count(range)) doesn't seem practical.
=IF(C16=C15,1,0)+IF(D16=D15,1,0)+IF(E16=E15,1,0)+IF(F16=F15,1,0)+IF(G16=G15,1,0)+IF(H16=H15,1,0)+IF(I16=I15,1,0)+IF(J16=J15,1,0)+IF(K16=K15,1,0)
Any help appreciated. Thanks!
Matt
Bookmarks