Hi ,
Wow ! Awesome. You are right. I did not notice that. Thank you very much for the response.! One last Question, I was trying to use the NOW() function to eliminate the need to enter the start date and end date in the cells as inputs to the formula. Can that be done? Like say NOW()-7 and combine it with criteria and countifs? since I want to monitor the weekly status for high/low/critical etc.?
Quote:
Originally Posted by wickedchew
I see now you're getting an error with the formula. Don't leave any cells blank in Sheet 1 where the formula is checking at, it'll produce an error - I don't know why.
If the cell should be blank, input a minus sign (-) or a space instead of a null value.
|