count column entries

  • Thread starter Thread starter Tim Barrett
  • Start date Start date
T

Tim Barrett

Hi

I have several Excel spreadsheets set to me which are
actually delimited files created on UNIX just containing
10 columns of data. They each have a variable number of
rows (around 500)

I want to avoid editing these (so no column headers,
database definitions in the files themselves) but produce
reports in a different excel 2000 workbook. Mainly I want
to count the number of occurrences of certain values in
specific columns.

COUNTIF seems the way to go but despite buying
Walkenbach's excel / vba book and internet searches I
can't find a way of searching a whole column without (a)
knowing how many entries in it and (b) setting up a column
header or name within the original spreadsheet. Any
suggestions?

Thanks
Tim
 
Hi Tim
this should be quite easy :-)
Could you just provide an example of your expected result
(and maybe some example rows of data).
All in plain text - no attachments please
 
Why can't you just reference the entire column?

=COUNTIF(A:A,"your_value")

HTH
Jason
Atlanta, GA
 
Back
Top