vba countif expression

Question

I need to count number of integers in top 1/3, middle 1/3 and bottom 1/3 of an array (test array in C6:C28). But I can't seem to get countif to work.

Range("C1").Select
    ActiveCell.FormulaR1C1 = "=MAX(R[2]C:R[24]C)"
Range("D1").Select
    ActiveCell.FormulaR1C1 = "=RC[-1]/3"
Range("E1").Select
    ActiveCell.FormulaR1C1 = "=2*RC[-1]"
Range("C2").Select
  ActiveCell.FormulaR1C1 = "=COUNTIF(R[4]C:R[26]C,""<D1"")"
Range("C3").Select
  ActiveCell.FormulaR1C1 = "=COUNTIF(R[3]C:R[25]C,"">E1"")"

assylias · Accepted Answer · 2012-07-28 13:00:13Z

2

One possible source of error is this "=COUNTIF(R[4]C:R[26]C,""<D1"")" - you should extract the cell address from the string:

"=COUNTIF(R[4]C:R[26]C,""<""&D1)"

Same comment for the next formula.

answered Jul 28, 2012 at 13:00

assylias

330k84 gold badges680 silver badges806 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

vba countif expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related