I've been trying to use the Search function but it's not working well for me today. I'm trying to take an average of cell values along a row. But the number of values varies. So my range is something like (B2:2), but I don't know how to write that in a statement that returns an average value.

Can anyone help?

Thanks in advance

-gshock