Counting cells with multiple criteria
Column AM contains the mm/dd/yyyy the job was finished
I need a COUNT of the cells in AJ that = "-1" and
for which the job was finished in a certain month
So the year can be *any* year?
=SUMPRODUCT(--(AJ1:AJ10=-1),--(AM1:AM10<""),--(MONTH(AM1:AM10)=n))
Where n = the month number: Jan = 1 , Dec = 12
--
Biff
Microsoft Excel MVP
"Charlie510" wrote in message
...
I'm trying to count the number of cells that meet criteria in multiple
columns:
Column AI contains a job number
Column AJ contains "blank", "0", or "-1"
Column AM contains the mm/dd/yyyy the job was finished
I need a COUNT of the cells in AJ that = "-1" and for which the job was
finished in a certain month
|