| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formular to Count values in cells of rows that meet criteria | Excel Worksheet Functions | |||
| Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
| count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
| count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
| Hiding rows that meet multiple conditions in excel | Excel Discussion (Misc queries) | |||
Linear Mode
