View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ryan Ryan is offline
external usenet poster
 
Posts: 124
Default Countif function with multiple column criteria?

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?