Count number of blank cells based on 2 conditions

[raisedwell]

I am working of a worksheet that returns the status of completion for a questionnaire that contains multiple categories that basically counts the number of empty cells for User Response, User Explanation, Mgr Approval and Mgr Notes. (Providing both the user and a manager with the number of unanswered cells that they have outstanding that must be completed. In the questionnaire the following columns are used.

RowA - Question number
RowB - Category
RowC - Question
RowD - Applicability
RowE - Rating
RowF - User Response
RowG - User Explanation
RowH - Mgr Approval
RowI - Mgr Notes

Although I have been successful in counting the blank cells for each category simply by using COUNTBLANK, I have run into a situation where the returned number of empty cells is based on 2 cell values. I need a formula that counts the number of empty cells G155 thru G197, unless F155 contains Yes, then only count the empty cell for G155 if it is not greater than 1.

Logic spelled out:
If cell F155 equals the word "Yes" AND cell G155 is less than 0 then return a value of 1, if G155 is greater than 0 then return 0, otherwise if F155 doesn't equal "Yes" then count the number of blank cells between G155 thru G197.

Examples:

Cell155 Value	Cell G155 Value	Then Return
Less than 0	Less than 0	number of empty cells between G155:G197
Contains "Yes"	Less than 0	Count cell G155 as 1 empty cell
Contains "Yes"	Greater than 0	Return 0

Any help would be greatly appreciated.

Thanks in advance.

 

[Fluff]

How about

=IF(F155<>"Yes",COUNTBLANK(G155:G197),IF(G155>0,0,1))

 

[raisedwell]

PERFECT!!!!! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.