The formula below doesn't seem to be working. What I want to say is IF O19
is 75% but less than 100% AND V19 is 100%, then return a 1, otherwise
leave the cell blank. Thanks for your help

=SUMPRODUCT(--(O19=75%),--(O19<99.999%),--(V19=100%),1,"")