Good evening ladies and gentlemen, I'm new here and this forum has already been a huge help to me.
I'm creating a fantasy F1 spreadsheet and I'm making some great progress considering I only started learning excel 3 days ago.
But I've come across problem. I am currently using the following formula:
=SUM(LARGE(H29:H34,{1,2,3}))
Because the above is referencing a table where some results are not yet posted (because races haven't occurred yet), when referencing empty cells it is returning the error #NUM!
Is there a way to add an IF (or anything else) to my above formula so that it ignores empty cells and in turn produces an empty cell as a result?
Thanks in advance for any assistance you can offer.
Bookmarks