Thanks for all the replies! But I think I may not have provided enough information...
I have a series of fomulas (from cell D8 to H8) using data in columns T, U, V, etc (all on the same sheet)
So cell D8 has the formula: =IF(T8=2,"6",IF(T8=1,"3",IF(T8=0,"0")))+IF(T9=2,"4",IF(T9=1,"2",IF(T9=0,"0")))+IF(T10=2,"6",IF(T10=1,"3",IF(T10=0,"0")))+IF(T11=2,"4",IF(T11=1,"2",IF(T11=0,"0")))
E8 has =IF(T14=2,"4",IF(T14=1,"2",IF(T14=0,"0")))+IF(T15=2,"1",IF(T15=1,"1",IF(T15=0,"0")))
F8 has =IF(T17=2,"4",IF(T17=1,"2",IF(T17=0,"0")))+IF(T18=2,"4",IF(T18=1,"2",IF(T18=0,"0")))+IF(T19=2,"4",IF(T19=1,"2",IF(T19=0,"0")))
G8 has =IF(T21=2,"2",IF(T21=1,"1",IF(T21=0,"0")))+IF(T22=2,"2",IF(T22=1,"1",IF(T22=0,"0")))+IF(T23=2,"2",IF(T23=1,"1",IF(T23=0,"0")))
H8 has =IF(T25=2,"2",IF(T25=1,"1",IF(T25=0,"0")))+IF(T26=2,"4",IF(T26=1,"2",IF(T26=0,"0")))
So I'm trying to copy the formulas above into cells D9 - H9 referencing the data in column U, the next would be copying the formulas into D10-H10 referencing column V, so on and so forth...
Sorry, I'm very new to Excel and I'm sure there's a 'better' way to do this but I"m already on this path....
Thanks again for the help!