Calculating a value but omitting cells with empty data

[Andrew Chalk]

I want to calculate a value based on several cells in say row 4. However, I
do not want to include values in any columns that do not also have a
non-missing value in, say, row3. Thus my calculated cell in, say column A,
should have some syntax like:

IF A3 <> MISSING THEN
< do calculation of value>

I hope this is clear.

What is the proper syntax for the pseudocode that I have above?

Thanks!

 

[Luke M]

Depends on what your calculation is. Are you summing, counting, multiply,
etc.?Each has their own formula structure.

For instance, the basic summing one is
=SUMIF(3:3,"<>"&"",4:4)
Sums every value in row 4 that doesn't have a corresponding blank cell in
row 3.
Similary, counting is
=COUNTIF(3:3,"<>"&"",4:4)

You could also look at other ways of using IF functions to limit data sets.

 

[Luke M]

Depends on what your calculation is. Are you summing, counting, multiply,
etc.?Each has their own formula structure.

For instance, the basic summing one is
=SUMIF(3:3,"<>"&"",4:4)
Sums every value in row 4 that doesn't have a corresponding blank cell in
row 3.
Similary, counting is
=COUNTIF(3:3,"<>"&"",4:4)

You could also look at other ways of using IF functions to limit data sets.

 

[Andrew Chalk]

It is actually a cell calculation. An example is:

=(G13-G12)/G12

If G12 is not zero I want the above calculation to be done.

If it is zero I want to not do the above calculation, but the value zero to
be used instead

Thanks.

 

[Andrew Chalk]

It is actually a cell calculation. An example is:

=(G13-G12)/G12

If G12 is not zero I want the above calculation to be done.

If it is zero I want to not do the above calculation, but the value zero to
be used instead

Thanks.

 

[Harlan Grove]

It is actually a cell calculation. An example is:

=(G13-G12)/G12

If G12 is not zero I want the above calculation to be done.

If it is zero I want to not do the above calculation, but the value zero to
be used instead

....

=IF(COUNT(1/G12),G13/G12-1,0)

 

[Harlan Grove]

It is actually a cell calculation. An example is:

=(G13-G12)/G12

If G12 is not zero I want the above calculation to be done.

If it is zero I want to not do the above calculation, but the value zero to
be used instead

....

=IF(COUNT(1/G12),G13/G12-1,0)