will try to make this as brief as possible. Here's my example:

workbook has several 'sheets' in it, for now we'll say 4. Sheet 4 has been
renamed to Skeleton, and Sheet 3 is called Values. Sheets 1-2 are named
Alpha & Beta. The Skeleton sheet is a diagram of the rest of the sheets.
All the VLOOKUP codes are there, I'm assuming that Sheets Alpha & Beta 'pull'
the formulas onto their pages. However, I need a formula that will count the
number of entries on those two pages & calculate. Right now the Skeleton
sheet has a formula in cell C29 that reads: =COUNT(A5:A26)*120. (The cells
A5:A26 are numbered consecutively from 1-22) I thought the way to insert the
info on the Alpha sheet was to type =skeleton!c29...but I need it to count
only the *nonblank* rows on each sheet. So, say Alpha has info on 5 rows, I
need the calculation to do 5x120. If Beta has 10 rows of info, I need the
calc to do 10x120. Instead, it's counting the whole info from the Skeleton
sheet (22x120).

I inherited this project from someone who has left, and I'm just about at my
wits' end! Can anyone help!????

thanks