I have two columns, Column AF contains a Yes or No drop down (Range AF25 to AF39) and AC contains in times in the hh:mm format (AC25 to AC39). I then have a cell G33 which contains the total amount of time.
I would like G33 to SUM only the times that have 'No', example below:
In the above example, Cell G33 would then display 0:15.
I think it's some sort of LOOKUP formula but just can't get my head around this one.. . Any help would be muchly appreciated?
Many many thanks,