Good afternoon,
I have two columns (F and G), some have a value in and some do not. I want to work out the average of the two columns, so am using:
=AVERAGE(F4:G4)
However, on the row where the values are empty in columns F and G it gives an error message. How can I make it so the cell will just appear blank rather than have a message in?
Many thanks
Bookmarks