Hi
You can also use the following array formula
SUM(IF((A2:A5="A")*(B2:B5="WE")*(C2:C5="Jan"),1))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"ccreed61" wrote in message
...
Need total of column A (Consumer's Names) who have been assigned to
specific
department (column B) in the month of January (Column C), February, etc. I
have tried different formulas already posted but I'm not having any luck.
I
am using Excel 2003. Thanks for your help in advance.