View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CandiC CandiC is offline
external usenet poster
 
Posts: 37
Default Sum If - I think

I have a worksheet with data in Columns D, E, F, G, and H that I will use to
calculate column I. If E2 contains a numeric value, then transfer that value
to I2, but if E2 is Blank or NA then use the product of (D2*G2), if colums
D2, E2, G2 are blank or NA then return the value of zero.

Can someone please help?