SUMIF / COUNTIF or PIVOTTABLE for This DATASET

Hello everyone!

I am trying to work out this situation i have for a report.

I have a column with Country Names(duplicates) on the Left, Dates in Row 1 date increment is by 1, total dates could be upto 2-3 years meaning upto 1000 columns of Data, for easy referencing I have formatted it as Table. The data under those dates corresponding to countries could be either 1 or 0 based on an if condition.

In a second Worksheets, I have User input cells collecting start and end date. And I need SUmif or countif function to get a count or sum of all 1's for the specified date from sheet 1 for Unique list of Countries.

Any help will be appreciated... posting a sample data file.

Sheet2

B2=IF(Sheet2!$A2<>"",SUMPRODUCT((Sheet1!$A$2:$A$100=Sheet2!$A2)*(Sheet1!$B$1:$AZ$1>=Sheet2!$M$1)*(Sheet1!$B$1:$AZ$1<=Sheet2!$M$2)*(Sheet1!$B$2:$AZ$100)),""

copy down