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