Counting blank cell issue

[DCR]

I need to count the number of orders that have not been reviewed yet. I have
been using countblank(O43:O5687). this works as long as some one updates the
formula when new orders are added. I am thinking I want a macro that will
find the last row using the order number in column A , then count the blank
cells in column O for order review, and also count the blank cells in
column t for outstanding orders.

Thanks
Clayton

 

[DCR]

The totals should be in cells b3 and b6

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Don Guillett]

I suggested a self adjusting defined name range to use in the formula.