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

Sumif Greater than 0
 

Try this.

=IF(G70,G7+(F7*0.15),F7*0.15)

Did that work?

Mike

" wrote:

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

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

Sumif Greater than 0
 

Hi Bob


No I am trying to put the formula in H7

Lindsey

Sumif Greater than 0
 

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

" wrote:

Hi Bob


No I am trying to put the formula in H7

Lindsey

Sumif Greater than 0
 

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)

wrote in message
oups.com...
Hi Bob


No I am trying to put the formula in H7

Lindsey

Sumif Greater than 0
 

=F7*15%+MAX(G7,0)
--
David Biddulph

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

Sumif Greater than 0
 

Thankyou all :-)

Got it working now

Lindsey