Hi, Just wanted to know if the formula below can be shortened? I need to do it 3 more times for 3 or 4 more rows... Thanks for any help on this.
=COUNTIF(G18,">""")+COUNTIF(L18,">""")+COUNTIF(Q18,">""")+COUNTIF(V18,">""")+COUNTIF(AA18,">""")+COUNTIF(AF18,">""")+COUNTIF(AK18,">""")+COUNTIF(AP18,">""")+COUNTIF(AU18,">""")+COUNTIF(AZ18,">""")+COUNTIF(BE18,">""")+COUNTIF(BJ18,">""")+COUNTIF(BO18,">""")
I do know that the other rows will change the number 18 value (Row), so this is why I can't just paste and go, I would have to manually change the 18 value for the new rows... Thanks.
Bookmarks