I have 3 cells in a row and i would like the third cell to display a count of
the first 2 cells. Ie if A1 has data in it and A2 is blank i would like A3 to
display 1. And if both A1 and A2 have data in them for it to display 2.

Many thanks