Hello,
I know how to do this using COUNTIF (or COUNTIFS) which is super easy, but I'm intentionally trying to do it the hard way to improve my Excel array handling skills . I'm trying to use the COUNT function in conjunction with the IF function in the array format to count only the number of TRUE values, in this case the number of cells that have values greater than 10, so I'm trying to write something like this:
{=IF((A1:D1>10),(COUNT(A1:D1)))}
But I can't get it to work, (and I see from the Evaluate Formula dialog that there is no one-to-one correlation between the IF test and the Count, so the COUNT portion of the formula just does its counting to "4" and disregards the IF condition ).
Thanks for any suggestions!
I know how to do this using COUNTIF (or COUNTIFS) which is super easy, but I'm intentionally trying to do it the hard way to improve my Excel array handling skills . I'm trying to use the COUNT function in conjunction with the IF function in the array format to count only the number of TRUE values, in this case the number of cells that have values greater than 10, so I'm trying to write something like this:
{=IF((A1:D1>10),(COUNT(A1:D1)))}
But I can't get it to work, (and I see from the Evaluate Formula dialog that there is no one-to-one correlation between the IF test and the Count, so the COUNT portion of the formula just does its counting to "4" and disregards the IF condition ).
Thanks for any suggestions!