IF with #DIV/0!

D

DKY

The first one didnt work papou, but the last one worked. Thank you bot
for the help. I didnt even think of using count
 
B

BenjieLop

The terms in Papou's formula are separated by a semicolon ";" while tha
of Frank's are by a comma "," so if you replace the semicolon with
comma, Papou's formula should work.
 
Top