Nel post
*AndyO_UK* ha scritto:

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

Hi Andy,

I'm not sure to have well understood...

Try this one:

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


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy