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
Bookmarks