R
Raza
I'm using this formula to determine the top four scores of a competitions
series:
=SUMPRODUCT(LARGE(F2:K2,ROW(INDIRECT("1:4"))))
It works great, but not everyone has done four competitions and since those
cells empty, I get a #NUM! error.
Is there a way to insert zeros into the empty cells, or is there a better
formula?
Thanks!
series:
=SUMPRODUCT(LARGE(F2:K2,ROW(INDIRECT("1:4"))))
It works great, but not everyone has done four competitions and since those
cells empty, I get a #NUM! error.
Is there a way to insert zeros into the empty cells, or is there a better
formula?
Thanks!