Excel spreadsheet

Closed
misspaula - Aug 29, 2010 at 01:08 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 3, 2010 at 07:16 PM
Hello,

I would like a cell to contain the sum of one row, but if the second row has figures entered i would like it to show that; e.g.

Q8 has 20.00
Q9 is blank
so cell S8 has 20.00

Q8 has 20.00
Q9 has 21.00
So i want S8 to say 21.00

Thanx


Related:

1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Sep 3, 2010 at 07:16 PM
Hope I'm not too late:
In cell S8 put in:
=IF(Q8<>"",IF(Q9<>"",Q9,IF(Q9="",Q8)))
0