If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating a value but omitting cells with empty data
I want to calculate a value based on several cells in say row 4. However, I
do not want to include values in any columns that do not also have a non-missing value in, say, row3. Thus my calculated cell in, say column A, should have some syntax like: IF A3 MISSING THEN do calculation of value I hope this is clear. What is the proper syntax for the pseudocode that I have above? Thanks! |
#2
|
|||
|
|||
Calculating a value but omitting cells with empty data
Depends on what your calculation is. Are you summing, counting, multiply,
etc.?Each has their own formula structure. For instance, the basic summing one is =SUMIF(3:3,""&"",4:4) Sums every value in row 4 that doesn't have a corresponding blank cell in row 3. Similary, counting is =COUNTIF(3:3,""&"",4:4) You could also look at other ways of using IF functions to limit data sets. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Andrew Chalk" wrote: I want to calculate a value based on several cells in say row 4. However, I do not want to include values in any columns that do not also have a non-missing value in, say, row3. Thus my calculated cell in, say column A, should have some syntax like: IF A3 MISSING THEN do calculation of value I hope this is clear. What is the proper syntax for the pseudocode that I have above? Thanks! |
#3
|
|||
|
|||
Calculating a value but omitting cells with empty data
It is actually a cell calculation. An example is:
=(G13-G12)/G12 If G12 is not zero I want the above calculation to be done. If it is zero I want to not do the above calculation, but the value zero to be used instead Thanks. "Luke M" wrote in message news Depends on what your calculation is. Are you summing, counting, multiply, etc.?Each has their own formula structure. For instance, the basic summing one is =SUMIF(3:3,""&"",4:4) Sums every value in row 4 that doesn't have a corresponding blank cell in row 3. Similary, counting is =COUNTIF(3:3,""&"",4:4) You could also look at other ways of using IF functions to limit data sets. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Andrew Chalk" wrote: I want to calculate a value based on several cells in say row 4. However, I do not want to include values in any columns that do not also have a non-missing value in, say, row3. Thus my calculated cell in, say column A, should have some syntax like: IF A3 MISSING THEN do calculation of value I hope this is clear. What is the proper syntax for the pseudocode that I have above? Thanks! |
#4
|
|||
|
|||
Calculating a value but omitting cells with empty data
"Andrew Chalk" wrote...
It is actually a cell calculation. An example is: =(G13-G12)/G12 If G12 is not zero I want the above calculation to be done. If it is zero I want to not do the above calculation, but the value zero to be used instead .... =IF(COUNT(1/G12),G13/G12-1,0) |
Thread Tools | |
Display Modes | |
|
|