Use SUMPRODUCT.
You'll see details as to how its done in the archives of this newsgroup.
--
David Biddulph
<Jason Stearns wrote in message ...
I have a spreadsheet that has dates in one column and reasons in another. I
want to be able get a total count of rows that fall between two specific
dates and have "Active Learner" for the reason column. Any suggestions
would be greatly appreciated as I have been frustrated trying to get this
to work.
Thanks,
Jason
EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorials...tom-pagin.aspx