M
marsupilami
Hi!
I've got two cells that contain the start and end row of a matrix in
sheet.
I want to use these row numbers in a =COUNT.IF formula to count th
number of specified instances in this matrix.
But my problem is this; how can I use the values in the two cell
inside the COUNT.IF formula??
I should look something like this;
=COUNT.IF(F"cell1":F"cell2";"=argument")
As you can see, the column (F) is specified in the formula but the ro
number needs to be fetched from cell1 and cell2.
Can anyone help me with the correct syntax?
Thanks!
-M
I've got two cells that contain the start and end row of a matrix in
sheet.
I want to use these row numbers in a =COUNT.IF formula to count th
number of specified instances in this matrix.
But my problem is this; how can I use the values in the two cell
inside the COUNT.IF formula??
I should look something like this;
=COUNT.IF(F"cell1":F"cell2";"=argument")
As you can see, the column (F) is specified in the formula but the ro
number needs to be fetched from cell1 and cell2.
Can anyone help me with the correct syntax?
Thanks!
-M