Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

summing a series of cells where one of the cells = zero

In a simple (shopping list like) spread sheet I want to calculate a total value.

so it might be:


a1*b1 = c1

a2*b2 = c2

a3*b3 = c3

total of c1+c2+c3 in c4


This works fine is there are entries in all of the a and b cells - giving a numeral in all of the c cells.

But if, for example, a1 is zero or if a1 has no entry, then it won't calculate c4.


I use in c1 =if(a1*b1>0,a1*b1,"") because I only want to see "non-blank" cells

I could use in c1 =if(a1*b1>0,a1*b1,0) but then i get a heap of "0" cells throughout the sheet


The above example is simplified.


Any help gratefully received!


Thanks


Bill

MacBook Pro 15, Mac OS X (10.6.4)

Posted on Aug 1, 2015 3:42 AM

Reply

There are no replies.

summing a series of cells where one of the cells = zero

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.