Why wouldn't even be a SUMPRODUCT problem?

=IF(AND(O1975%,O19<1,V191),1,"")

--


Regards,


Peo Sjoblom


"KC" wrote in message
...
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,"")