ahh, you are absolutely right....sorry about that.
I'm glad you have it fixed, but incase you did want the correct formula:-
Edit:- BTW, that formula leaves 0 in the cell if C75 is NOT "YES". If you would rather the cell be blank:-![]()
=IF(C75="YES",MIN(COUNTIF(K14:M14,">"&0)*60,150),0)
![]()
=IF(C75="YES",MIN(COUNTIF(K14:M14,">"&0)*60,150),"")
Bookmarks