Count Data Meeting Criteria Across Columns Meeting Criteria

Hi,

I have a problem I am trying to resolve with a tasking spreadsheet in that I am trying to count the number of due dates in a table that meet specific criteria, but only count in columns meeting specific criteria. I've tried with sumproduct, but it returns an error, and I don't believe countifs will work with finding the specific column.

I've attached an example spreadsheet with data, and a result area highlighted in yellow.

In the spreadsheet, I would like to count the number of dates meeting criteria for K1(TaskID1) and J2(05/04/15) within the data table A1:F13, but only in the columns labeled "Due Date". In the original spreadsheet, I have multiple due date columns (relating to different phases of the project).

I wrote a formula in cell K2 with what I believe I thought I knew it should be:
=SUMPRODUCT(($C$2:$F$13=$J2)*($A$2:$A$13=K$1)*($A$1:$F$1="Due Date"),$C$2:$F$13)

But it's returning an error.

You all have been of great help in the past, and I again would appreciate any advice you could give.

Thanks in advance!

Example.xlsx

Thanks for the response Marvin. I agree with restructing the data, and it would make a few other data functions I have to do easier. Unfortunately, management wants to see the different phases similar to the example I gave.

However, I did end up solving this I believe after mucking around for a bit, and it turned out to be pretty simple (slapping forehead). The ranges all needed to be the same. So the formula worked with this:

=SUMPRODUCT(($A$1:$F$13=$J2)*($A$1:$A$13=K$1)*($A$1:$F$1="Due Date"))

I do appreciate the suggestion and your time.