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
|