Hi
I have weekly reports and then a monthly report every month. On the
weekly report, engineers enter their change order numbers....on the
monthly report I want a formula that tells me how many change orders
they've had from each worksheet. So if the change orders are in C56,
C57, C58, C59, C60 on the weekly report, but each week the engineer
only had 2 each week. I want there to be a formula that says of the 5
cells from each of the 4 weekly reports, how many were populated with
a change order number.


Thanks
Kimmie40