View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerardo Gerardo is offline
external usenet poster
 
Posts: 27
Default count if for more than one criteria

For several items listed in rows, I have one column with values "old" and
"new" . In each column in the array I have months from 01/2004 through
12/2014. I want to count values in the array that are more than 0.2 and "new"
in one row and more than 0.2 and "old" in a second row. The problem is that
count if only counts either more than 0.2 values or "old" or "new".

Any ideas?