View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Counting Cells with Multiple Range Criteria (Excel 2003)

.. I also need it to work for date ranges between 02-01-05 and 01-31-06,
so I can't limit it to just the year


Try it like this then, with explicit, unambiguous date ranges defined:
=SUMPRODUCT((A1:A4=--"2 Jan 2005")*(A1:A4<=--"31 Jan 2006")*(B1:B4=--"2
Jan 2005")*(B1:B4<=--"31 Jan 2006"))
Success? hit the YES below
--
Max
Singapore
xde
---