How do i count cells where the adjacent cell is of certain string value?

**timatrix17** · 01-13-2012, 06:52 AM

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

**Fotis1991** · 01-13-2012, 06:57 AM

Hi and welcome to the forum.

Your requirement(for me), is not clear.

Would you like to upload a small sample workbook?

**Marcol** · 01-13-2012, 07:06 AM

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

Please Login or Register  to view this content.

Does this help?

**timatrix17** · 01-13-2012, 07:28 AM

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

**Fotis1991** · 01-13-2012, 07:39 AM

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..