Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Countif
I'm attempting to construct a countif statement which is conditional on 2
seprate columns of data using the following formula produces a 0 response =COUNTIF($K:$K,(AND($C:$C=1,$I:$I=0))) What I need: Count the numeric values in "K" IF the values in "C" are equal to 1 AND the values in "I" are equal to 0 I'm using the entire columns in the formula do to the fact that the number of data rows extracted from another system is variable daily Any assistance would be appreciated... -- Joe Mac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Countif
Check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Joe Mac" wrote: I'm attempting to construct a countif statement which is conditional on 2 seprate columns of data using the following formula produces a 0 response =COUNTIF($K:$K,(AND($C:$C=1,$I:$I=0))) What I need: Count the numeric values in "K" IF the values in "C" are equal to 1 AND the values in "I" are equal to 0 I'm using the entire columns in the formula do to the fact that the number of data rows extracted from another system is variable daily Any assistance would be appreciated... -- Joe Mac |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Countif
Jim...
Thank you for the guidance, this will produce a result by indicating a static range in using the formula, the additional challenge I'm facing is that the number of rows extracted daily is variable based on the activity of the production application of the total restricted from using the whole column, (65,536 rows)... if there were a way to dynamically identify the last row of the daily contiguous range that could be factored into a formula... -- Joe Mac "Jim Thomlinson" wrote: Check out this link... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Joe Mac" wrote: I'm attempting to construct a countif statement which is conditional on 2 seprate columns of data using the following formula produces a 0 response =COUNTIF($K:$K,(AND($C:$C=1,$I:$I=0))) What I need: Count the numeric values in "K" IF the values in "C" are equal to 1 AND the values in "I" are equal to 0 I'm using the entire columns in the formula do to the fact that the number of data rows extracted from another system is variable daily Any assistance would be appreciated... -- Joe Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF - more complex | Excel Worksheet Functions | |||
Complex or Conditional Countif(s) | Excel Worksheet Functions | |||
Countif Function, complex criteria | Excel Worksheet Functions | |||
Even more Complex COUNTIF functionality | Excel Worksheet Functions | |||
help please - complex countif, etc. functions | Excel Worksheet Functions |