Thread
:
Counting cells with multiple criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Counting cells with multiple criteria
try this where a1 has your date formatted the same
=sumproduct((ai2:ai22=1234)*(am2:am22=a1)*(aj2:aj2 2=-1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett