View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default count if for more than one criteria

Hi Gerardo

I have no idea what 0.2 means
If it means Month 2 then try the following
=SUMPRODUCT(($A$1:$A$1000="New")*(MONTH(($B$2:$B$1 00)=2))

--
Regards
Roger Govier

"Gerardo" wrote in message
...
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?