okay guys this is what my X4 formula is =COUNTIF($K$4:$V$4, "630")+COUNTIF($K$4:$V$4, "645")+COUNTIF($K$4:$V$4, "7")+COUNTIF($K$4:$V$4, "715")+COUNTIF($K$4:$V$4, "730")+COUNTIF($K$4:$V$4, "745")+COUNTIF($K$4:$V$4, "8")
As u can see i'm doing this formula with all these criteria but i want X5 to literally be the same thing but instead of K4 through V4 it needs to be K5 through V5 and I want to keep replicating this all the way down from X4 to X5 to X6 all the way down. can someone please help me????
As u can see i'm doing this formula with all these criteria but i want X5 to literally be the same thing but instead of K4 through V4 it needs to be K5 through V5 and I want to keep replicating this all the way down from X4 to X5 to X6 all the way down. can someone please help me????