I have a list of countries and each county can be of a certain category (rehab, end user.. etc (there are 5)
I want to have a counter to count the value of type (ie "rehab") if the cell containing country is of type x (ie albania).
Please help
Hi and welcome to the forum.
Your requirement(for me), is not clear.
Would you like to upload a small sample workbook?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Given you have 2010 use COUNTIFS()
Say Column A is "Countries" and Column B is "Category"
In say D2 your required country and in E2 the catagory to match
Then
Does this help?=COUNTIFS(A:A,D2,B:B,E2)
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Re: How do i count cells where the adjacent cell is of certain string value?
Thank you fotis i was about to upload but THANKYOU Marcol. i knew there was a way!
Back in 2005 i got 98% and fastest in the class for the Microsoft's written excel test. its good to get back on the excel wagon slowly
You are welcome.
As I have said many times for me where English is not my native language, sometimes hard to understand immediately the requirement of each questioner..
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks