Thanks for the suggestion Francis, but I'd rather not concatenate the columns
into a new column.

"Francis" wrote:

Assuming your data are in Col a and Col B
you need to add a helper column
in Col C, place this formula in C2 and copy down
=A2&" "&B2

oe you can place this in a faraway col and hide it

in col D, place this formula
=COUNTIF(C2:C11,"5 years")

adjust this to your range
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis
Am not a greek but an ordinary user trying to assist another



"Ryan" wrote:

Hello...

I'm hoping someone, much smarter than I, can help me find a solution to my
problem.

Problem:
My spreasheet looks like this (two columns):
1 day
2 months
5 years
6 weeks
5 years
7 days
1 month
3 years
1 day
6 weeks

I want to use a count function to count the number of times 5 years occurs,
and I am having a hard time getting a nestedif function to make this happen.

Any suggesstions?