View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lindsey1975@googlemail.com is offline
external usenet poster
 
Posts: 13
Default Sumif Greater than 0

Hi All

I can't seem to get the last bit correct,

What i am trying to do is if F7 x 15% (which is ok)
then if G7 is Greater than 0 and the figure in to the total sum



=SUM(F7*0.15)SUMIF(G70+G7)

Any suggestions

Lindsey