count column entries

[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

 

[Frank Kabel]

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

 

[Jason Morin]

Why can't you just reference the entire column?

=COUNTIF(A:A,"your_value")

HTH
Jason
Atlanta, GA