Hi,
I have a spreadsheet that has many rows and columns and the columns count to give the total, example.
Row J5 shows =Sum(J3:T3)+G3
Columns J-T cells have quantities entered (ie J3 = 5, H3 = 20, I3 = 15 etc)
W3 would calculate the quantities and = 40
Cell G3 is an estimated figure (lets say 45) which updates after 3pm each day
The total so far = J-T +G3 = 85
H3 is updated at 3pm and it may change to 52 from 45 (a plus up of 7)
The total would then be 92
Cell I3 is the Adj cell which = H3 minus G3 showing 7
I cannot get cell W3 to calculate (J3-T3+G3) and add I3 as if H3 is blank (not updated till 3pm), W3 would show a different figure.
How do I have this as a calculation if cell H3 is blank
many thanks
Pugg
Bookmarks