Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Empty Cell ( blank Cell ) | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions | |||
set zero cell as blank cell | Excel Worksheet Functions |