Count If Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a big spreadsheet with over 2,000 rows. I want to do a count of a value based on the current row selected
Is this possible? The first 8 rows is where I display that data, they are frozen using freeze panes

I have this alread

=COUNTIF($O$17:$O$2300,F2
I needs something lik
=countif($o$17: cell.currentrow,f2

Thanks in advanc
 
Hi
why not enter the following formula in P17
=COUNTIF($O$17:$O17,F2)
and copy this down
 
Say the current row is 200, so you want to do a COUNTIF on O17:O200. Since
you can't include the active cell in your formula, I would assume that you
want the formula in an adjacent column, say P. Put the following formula in
P200:

=COUNTIF($O$17:OFFSET($P200,0,-1),$F$2)

This should give you what you want.

--

Vasant



Newbie said:
I have a big spreadsheet with over 2,000 rows. I want to do a count of a
Click to expand...
value based on the current row selected.
 
If you're looking for a formula, at the top row use

=COUNTIF($O$17:$O17,$F$2)

then copy it down. That will count from O17 through whatever row you happen
to copy it down to.


Newbie said:
I have a big spreadsheet with over 2,000 rows. I want to do a count of a
Click to expand...
value based on the current row selected.
 
Pretty dumb solution on my part ... but why use a simple technique when a
more complicated one is readily available? <g>
 
I am not sure this will give me what I want

For exampl

This is row O (BELOW). Looking for cells that contain 1

If I click on row 4, I get 3,
If I click on row 7, I get 4
If I click on row 2, I get

1
2
3
4
5
6
7
8
 
Thanks for the assistance

I figured it out

[G2].Formula = "=COUNTIF($O$17:$O$" & ActiveCell.Row & ", F2)"
 
Back
Top