Hassad's is working perfectly. Thanks.
Now, if I wanted it to take various sections of the sheet and apply the formula and then total them together, would I simply change it to this?:
=SUM((SUMPRODUCT(SIGN(COUNTIF(OFFSET(I7:K32,ROW(I7:I32)-ROW(I7),),"<>"))))+(SUMPRODUCT(SIGN(COUNTIF(OFFSET(I36:K36,ROW(I36:I80)-ROW(I36),),"<>"))))+(SUMPRODUCT(SIGN(COUNTIF(OFFSET(I84:K109,ROW(I84:I109)-ROW(I84),),"<>")))))
The original formula (for just one section of the sheet), was this:
=SUMPRODUCT(SIGN(COUNTIF(OFFSET(I7:K32,ROW(I7:I32)-ROW(I7),),"<>")))
The original formula totaled a 3. However, when I try to total the three sections, it's coming up with a 26. It should be totaling a 3, as there is no data in any of the other two sections. I can post the data, if needed.
Bookmarks