Count rows that meet 2 conditions in Excel 2007

J

Jason Stearns

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/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx
 
J

Jason Stearns

David and Ashish thank you both so much for your help with this. It worked like a charm!



Ashish Mathur wrote:

Re: Count rows that meet 2 conditions in Excel 2007
29-Sep-09

Hi,

=sumproduct((B2:B50>=B52)*(B2:B50<=B53)*(C2:C50="Active Learner")

B52 and B53 holds the start and end date respectively

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

in message
EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to Visio Conversion 1
Outlook Unexpected Error - Distribution Lists 1
Sorting Multiple Columns in Excel 2003 3
can you modify owners category in contacts as a delegate? 1
pwer point to print 1
Publisher Labels 1
designing a form 1
Move Business Contact Manager database from PC onto server 1

Top