Sumif Greater than 0

  • Thread starter Thread starter lindsey1975
  • Start date Start date
L

lindsey1975

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(G7>0+G7)

Any suggestions

Lindsey
 
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)
 
Looking again, your own formula wasn't a million miles away. Try this in H7
as an alternative.

=SUM(F7*0.15)+SUMIF(G7,">0",G7)

Mike
 
Then this is probably what you want

=G7+MAX(F7*0.15,0)


--
HTH

Bob

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