if blank cell, don't calculate

[Guest]

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

 

[Guest]

What cell do you want to check if blank"

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

 

[Guest]

Hey,

Thanks, that works.

What cell do you want to check if blank"

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