Counting if cell = blank

[Puggwash63]

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

[AliGW]

Please provide a sample workbook.

[Special-K]

..with your expected results

[Puggwash63]

It does not seem to load when I click on the attached section.

Any other way of getting it across

[FDibbins]

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Puggwash63]

I have tried that but the file does not upload

[FDibbins]

How big is the file? We only need a small sample workbook, with just enough info to show what you are working with, and what you want

[Puggwash63]

SUN.xlsb

Apologies for the delay as had trouble attaching the file.

As you can see Cell W shows =SUM(J2:T2)+G2

If I add a figure to Cell H2, it will show I2 as increased or decreased.

What I want is to add I2 to Cell W2 but if cell H2 is blank it always deducts I2.
If H2 is blank, I want cell W2 not to add I2.
Is this possible

[FDibbins]

Perhaps this?
=SUM(J2:T2)+G2+IF(H2="",0,I2)

[Puggwash63]

wow, as simple as that.

Perfect

Many thanks for the quick response

Pugg

[FDibbins]

Happy to help

Actually, that could be simplified to this...
=SUM(J2:T2,G2,IF(H2="",0,I2))