| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif Greater than 0
Hi Bob
No I am trying to put the formula in H7 Lindsey |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif Greater than 0
Thankyou all :-)
Got it working now Lindsey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf: use of greater or less than operators in Criteria | Excel Worksheet Functions | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| SUMIF with a Greater Than | Excel Discussion (Misc queries) | |||
| HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A # | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
