the countif formula does tell me how many cells, but I think I really want to
know the range. Like a2:a6. Then I could use this result in a vlookup.

Thank you,

Gary

"Bernard Liengme" wrote:

=COUNTIF(A:A,A1) might work for you
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary" wrote in message
...
I need to do calculations on multiple cells that are in multiple rows. The
rows that I need to work with will all have the same value in the first
column. The spreadsheet is already sorted by the first column, I just
need
to know how many rows have the same value in the first column. Then I
will
write a formula that will use that range for doing some basic math
calculations.

Thank you,

Gary