One way:
=SUMPRODUCT(SIGN(COUNTIF(OFFSET(I7:K7,ROW(I7:I32)-ROW(I7),),"<>")))+SUMPRODUCT(SIGN(COUNTIF(OFFSET(I36:K36,ROW(I36:I80)-ROW(I36),),"<>")))+SUMPRODUCT(SIGN(COUNTIF(OFFSET(I84:K84,ROW(I84:I109)-ROW(I84),),"<>")))
One way:
=SUMPRODUCT(SIGN(COUNTIF(OFFSET(I7:K7,ROW(I7:I32)-ROW(I7),),"<>")))+SUMPRODUCT(SIGN(COUNTIF(OFFSET(I36:K36,ROW(I36:I80)-ROW(I36),),"<>")))+SUMPRODUCT(SIGN(COUNTIF(OFFSET(I84:K84,ROW(I84:I109)-ROW(I84),),"<>")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks