Excel Formula Problems

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

I am creating an Excel spreadsheet that has three
columns. The first column shows the persons name. The
second column shows forecasted hours. The third column
shows actual hours.

What I am trying to do is to add up all the forecasted
hours throughout the year (there are 12 forecasted & 12
actual hrs columns, each months actuals hours column
comes right after that months forecasted column) But only
if there arent any actual hours in the actual hour
column.

Here is a formula that I tried using, but does not work.
=SUM(G4)+SUMIF(H4,"",H4)
Cell G4 is the forecasted hours for the person, H4 is the
actual hours cell. So I want to add up G4 if there is no
H4.

Thanks in advance for your help!
 
Hi Colin,
You question speaks of SUMMING but =SUM(G4) is the same as =G4.
Do you want to display the G4 value only when the H4 cell is empty? Let's
read that as: when H4 has a value do nothing, otherwise show G4. Use
=IF(H4>0,"",G4)

Sorry if I am misreading ... come back for more.
Bernard
 
Back
Top