# Office 365 - Need Sumif cell is not zero

#### tofulooooo

##### New Member
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. [/URL][/IMG]

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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

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.

Hi,

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

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

HTH

Mel

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]

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

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

HTH

Mel

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.

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))

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..

Last edited:
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

Replies
5
Views
2K
Replies
9
Views
3K
Replies
4
Views
627
Replies
26
Views
4K
Replies
1
Views
3K

### Forum statistics

1,203,467
Messages
6,055,590
Members
444,800
Latest member
KarenTheManager ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back