Sumproduct Help

[Guest]

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

 

[Franz Verga]

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

 

[Bob Phillips]

Is it not just

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


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Franz Verga]

Nel post *Bob Phillips* ha scritto:

Is it not just

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

Hi Bob,

that should work if the serials numbers in column A are entered as text, but
if they are formatted as numbers, I'm quite sure that it shouldn't work...


--
(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

 

[Bob Phillips]

The OP said serial "1" which is why I did it that way.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)