joining 2 countif's into a sumproduct? can't get syntax right

[firebladejr]

Hi,

I'm trying to check for 2 conditions before adding to the counter (data in column BH must = C, and Date in column K must be greater than or equal to a date in E26).

My two countifs are as follows:

Please Login or Register  to view this content.

the minus 1 on the end, is there to remove an additional "C" at the bottom of the spreadsheet which is used for a drop down menu.

Please Login or Register  to view this content.

an my attempt at joining the conditions is as follows:

Please Login or Register  to view this content.

The first two countif's work as expected. The SUMPRODUCT attempt is rejected when I try and input it.

Any help you could offer would be great.

[firebladejr]

found the correct format for anyone interested..

Please Login or Register  to view this content.

the -1 on the end was no longer required..