View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Sumif Greater than 0

Are you trying to put a formula in G7 that will check F7 and add the value
to a value already in G7?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
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