Hopefully this is what you asked for??
For the actual worksheet I am working on:
*columns a to k contain text and numbers or blanks - none of this data
is wanted for totals
*columns l,p,t,x,ab... contain text or are blank - these are the ones
we want the totals at the end of each row ("L to O" is a set of data,
so is "p to s" and so on. We want to know how many of these sets occur
in each row - if the beginning column (l, p etc) contains text then the
following 3 will too, otherwise blank

Thanks!
Lisa:)


--
Lisa W
------------------------------------------------------------------------
Lisa W's Profile: http://www.excelforum.com/member.php...o&userid=32497
View this thread: http://www.excelforum.com/showthread...hreadid=522894