SumProduct I believe

Hello,

I require help on a formula. I want the formula to do the following:

When excel finds this condition: CONCATENATE('Summary Trade Spend'!A7,"TY") in the range D:X I need it to count the number of cells that have a value in them in column X:X.

Let me explain this another way if that wasn't clear enough:

When a product name has a TY next to it I want my formula to count how many cells have values in them for those columns in a different set of columns.

All of the data for the above is in one spreadsheet, and the forumla result is in another. I have been told that SUMPRODUCT might be the answer, but only might. I dont quite understand the the sumproduct formula.

Any help would be graetly appreciated.

Thank you.

Este