if blank cell, don't calculate
 

Hello,

I was wondering how i could work in an if statement to check if the cell is
blank, is do nothing, if it contains a number for it to perform the following
function:

=SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$ 9571,0),0)

I'm trying to save some time because in some rows there is only 3 cells that
contain a number and 30000 parts, it takes like 5 minutes for it to fill down
and calculate.

Thanks in advance!

Dejan

What cell do you want to check if blank"

Try
=if(yourcell="","",your equation)

"Dan" wrote:

Hello,

I was wondering how i could work in an if statement to check if the cell is
blank, is do nothing, if it contains a number for it to perform the following
function:

=SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$ 9571,0),0)

I'm trying to save some time because in some rows there is only 3 cells that
contain a number and 30000 parts, it takes like 5 minutes for it to fill down
and calculate.

Thanks in advance!

Dejan

Hey,

Thanks, that works.


"bj" wrote:

What cell do you want to check if blank"

Try
=if(yourcell="","",your equation)

"Dan" wrote:

Hello,

I was wondering how i could work in an if statement to check if the cell is
blank, is do nothing, if it contains a number for it to perform the following
function:

=SUM(IF(make!$A$2:$A$9571=finally!Q2,make!$C$2:$C$ 9571,0),0)

I'm trying to save some time because in some rows there is only 3 cells that
contain a number and 30000 parts, it takes like 5 minutes for it to fill down
and calculate.

Thanks in advance!

Dejan