Heres my problem: I have two worksheets-one is the complete master worksheet which has all the salespeople data and the other worksheet is the individual salesperson worksheet which is linked to the master worksheet. On the linked worksheet, I havethe formula: =count(b3..m3) and it returns a value of 12. Well, there is 12 colums but only 3 has the actual results from the master sheet, the other 9 are blank but have the linking reference in them. How can I get it to only count the cells thatcontain the data that has been returned?
