Found something really fancy (array entered):
=SUM(--(MMULT(--(INDIRECT("A1:J20")<>""),TRANSPOSE(COLUMN(INDIRECT("A1:J20"))^0))>0))
Thanks for your help though.
Found something really fancy (array entered):
=SUM(--(MMULT(--(INDIRECT("A1:J20")<>""),TRANSPOSE(COLUMN(INDIRECT("A1:J20"))^0))>0))
Thanks for your help though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks