Sumproduct Help
 

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

Sumproduct Help
 

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

Sumproduct Help
 

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)


"AndyO_UK" wrote in message
...
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

Sumproduct Help
 

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

Sumproduct Help
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Franz Verga" wrote in message
...
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