Hi,

I have the following formula:

=SUMPRODUCT(('Data Table 1'!$D$7:$D$1311=A5)*(ISNUMBER(FIND("A",'Data Table 1'!$F$7:$F$1311))))

I need to modify the formula so that it looks like the following:

=SUMPRODUCT(('Data Table 1'!D7:D100="Unbalanced*")*(ISNUMBER(FIND("*A*",'Data Table 1'!F7:F100))))
I tried doing it myself but all I got was a value of 0

How do I make the above formual work?

Thanks in advace for any help.

Calli