Trying to find which function to use

  • Thread starter Thread starter J4shaw
  • Start date Start date
J

J4shaw

I apologise if this makes no sense at all!

I have a spreadsheet which is used for a hotel guest info log.
There is a column in each day for which country the guest is from, how they
heard about us, etc.
What I want to do is at the bottom of the s/sheet, have a key for the
country codes, and then have a tally next to it:


Country
Country Key Totals
Ger GERMANY
Fr FRANCE
Eng England
Ire IRISH
J JAPAN


I know you can use the sort function and do it manually that way, but I
wondered if there was a function that would auto find for instance 'GER' in a
specific column, and count the amount of times it occures, then put that
figure of times it occurs into a seperate designated cell?

Hope this makes sense, any help would be greatly appreciated
 
=COUNTIF(A:A,"Ger")
will count number of 'Ger' in column A

OR with Ger in a cell B1
=COUNTIF(A:A,B1)


If this post helps click Yes
 
Hi J4shaw,

At the end of the sheet, you can have data validation set, which list of the
keys and in the right cell of that validation cell, you can use COUNTIF
function.

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
Thanks guys, helps heaps

DILipandey said:
Hi J4shaw,

At the end of the sheet, you can have data validation set, which list of the
keys and in the right cell of that validation cell, you can use COUNTIF
function.

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
Click to expand...
 
Back
Top