Count rows that meet 2 conditions in Excel 2007
 

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

Count rows that meet 2 conditions in Excel 2007
 

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

Count rows that meet 2 conditions in Excel 2007
 

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 ...
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

Thanks
 

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

Thanks
 

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jason Stearns" wrote in message
...
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