Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |