mykal66
02-26-2015, 08:15 AM
Hi guys.
I'm stuck with a formula and looking for help if anyone can give me any pointers please?
I've used COUNTIF with several criteria in the past without any issues but this one is completely stumping me.
I have a spreadsheet which contain the following columns End Date & Sector: I need to count only items for a specific Sector that occurs for a specific sector e.g. Sales that end within a certain period e.g. March 2015
I have used a COUNTIF to count all items that occur in March 2015 (irrespective of the sector) as below which gives the right result.
=COUNTIF(Data!G6:G1000,">28/02/2015")-COUNTIF(Data!G6:G1000,">31/03/2015")
I'm stuck now trying to expand the formula to only return a count for items in s specific sector for that period. I've messed with sumproduct and countif(and but can't get anything to work.
I've attached an example as my description probably isn't the best. In the attached example F2 should show the count for sales in March 2016 which should be 5
As always thank for any help / pointers
Best wishes
Mykal
12924
I'm stuck with a formula and looking for help if anyone can give me any pointers please?
I've used COUNTIF with several criteria in the past without any issues but this one is completely stumping me.
I have a spreadsheet which contain the following columns End Date & Sector: I need to count only items for a specific Sector that occurs for a specific sector e.g. Sales that end within a certain period e.g. March 2015
I have used a COUNTIF to count all items that occur in March 2015 (irrespective of the sector) as below which gives the right result.
=COUNTIF(Data!G6:G1000,">28/02/2015")-COUNTIF(Data!G6:G1000,">31/03/2015")
I'm stuck now trying to expand the formula to only return a count for items in s specific sector for that period. I've messed with sumproduct and countif(and but can't get anything to work.
I've attached an example as my description probably isn't the best. In the attached example F2 should show the count for sales in March 2016 which should be 5
As always thank for any help / pointers
Best wishes
Mykal
12924