Finding top four scores, need to insert zero

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top