Sumproduct Help

A

AndyO_UK

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
 
F

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
Click to expand...

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
 
B

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)
 
F

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)
Click to expand...

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
 
B

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)
 
Top