Office 365 - Need Sumif cell is not zero

[tofulooooo]

Trying to calculate actual completed(row8) by adding daily consumption(row4).. If I just write a sum formula it will always be off.

So... I am trying to tell excel to only show SUM in row8 if row4 is not equal to "0" zero.

I've googled so much that I blacked out and lead to writing this thread.. Thanks in advance!

[/URL][/IMG]

 

[Mel Smith]

Hi and welcome to the Board,

So that we can understand what it is that you're looking for, is the figure in cell (row) 4 an inputted figure and what plus and/or minus what comprises the result you're looking for in cell (row) 8?

Mel

 

[tofulooooo]

Thank you!

(row) 4 is a formula pulled from 2 other sheets in the workbook.

(row) 8 needs to show "total of daily consumption" to that date. But... if daily consumption is zero then it should not calculate.

So..... It should show....

E8 = 3
F8 = 8
G8 = 13
H8 = 25
I8 = 45
J8, K8, L8 = should be blank

Side note: I have a conditional format to blackout all cells that are blank or zero. I want to add a rule for (rows) 2, 5 and 8 to turn all cells to the right black IF they have the same value to the left. This I could care less... Not important.

 

[Mel Smith]

Hi,

Might the following formula be somewhere near what you're trying to achieve?:

=if(e4=0,0,e4+d8)

HTH

Mel

 

[tofulooooo]

Thanks Mel! TIt kinda worked from B to I then it reset at M. Can I command it to add the highest digit to the left somehow?

[/URL][/IMG]

 

[Mel Smith]

Perhaps something along these lines (if I understood you correctly):

=IF(J23=0,(MAX(E25:I25)+J23)) adjust range and references accordingly.

HTH

Mel

 

[bonescoster]

I am not sure what you are summing but I think there is a way that you could do a simple IF statement that could help. If B8 is suppose to show a sum if B4 is not equal to zero then you can use a statement such as this in Cell B8: =if(B4=0,0,SUM(INPUT YOUR SUM HERE))

Hopefully this helps. Or you might need to specify what exactly you want to sum so we can help you better.

 

[bonescoster]

Sorry for my previous post some others are quicker typers then I am.

I believe this formula should work for you (I tried it and it seemed to work well). In Cell L8 you could put this formula and copy it left and right.

=IF(K4=0,IF(L4=0,0,K8+L4),IF(L4=0,0,K8+L4))

 

[tofulooooo]

Perhaps something along these lines (if I understood you correctly):

=IF(J23=0,(MAX(E25:I25)+J23)) adjust range and references accordingly.

HTH

Mel

This looks like it should work but its not.. It's giving me a FALSE value. Im tinkering with it a little... I swear I've seen this work before..

 

[tofulooooo]

Sorry for my previous post some others are quicker typers then I am.

I believe this formula should work for you (I tried it and it seemed to work well). In Cell L8 you could put this formula and copy it left and right.

=IF(K4=0,IF(L4=0,0,K8+L4),IF(L4=0,0,K8+L4))

This one worked exactly the same way this works.. =IF(I4=0,0,I4+H8)


I'm stumped. haha