David and Ashish thank you both so much for your help with this. It worked like a charm!
Ashish Mathur wrote:
Count rows that meet 2 conditions in Excel 2007
29-Sep-09
Hi,
=sumproduct((B2:B50=B52)*(B2:B50<=B53)*(C2:C50="A ctive Learner")
B52 and B53 holds the start and end date respectively
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Jason Stearns" wrote in message ...
EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorials...tom-pagin.aspx