Trying to find which function to use

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
 
J

Jacob Skaria

=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
 
D

DILipandey

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
 
J

J4shaw

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top