ExcelBanter - Sumif Greater than 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumif Greater than 0 (https://www.excelbanter.com/excel-discussion-misc-queries/137779-sumif-greater-than-0-a.html)

[email protected]

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

All times are GMT +1. The time now is 02:47 AM.