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

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

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