Hi

Currently I have the following string setup:

=SUMPRODUCT(--('Awaiting Further Info'!B2:B294="NU"),--('Awaiting Further
Info'!F2:F294="D"),'Awaiting Further Info'!I2:I294)

I now also need this to check Column A for all instances of serial "1" but I
cannot get the syntax right so grateful for your help.

Column 'B' is Company, Column 'D' is Circuit Type and Column 'I' is cost of
circuit per annum

Thanks, Andy