Sumproduct Help

[Curtis]

I currently use the formula below that works fine however I need to add in
another condition that only returns a value if the department number is in
the range of say 1400 to 1499

=SUMPRODUCT(--('[2010-01 Group Trial Balance.xls]Group Trial Balance -
Current'!$B$4:$B$278=$A68)*('[2010-01 Group Trial Balance.xls]Group Trial
Balance - Current'!$D$4:$BY$278))

Thanks

 

[JBeaucaire]

Adding book reference/sheet references back in yourself, the syntax would be:

=SUMPRODUCT(--($B$4:$B$278=$A68),
--($C$4:$C$278>=1400), --($C$4:$C$278<1500),
$D$4:$BY$278))

 

[JBeaucaire]

I just noticed the final range wasn't a single column, so you might need this:

=SUMPRODUCT(($B$4:$B$278=$A68) * ($C$4:$C$278>=1400) * ($C$4:$C$278<1500),
$D$4:$BY$278))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.

Adding book reference/sheet references back in yourself, the syntax would be:

=SUMPRODUCT(--($B$4:$B$278=$A68),
--($C$4:$C$278>=1400), --($C$4:$C$278<1500),
$D$4:$BY$278))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.

I currently use the formula below that works fine however I need to add in
another condition that only returns a value if the department number is in
the range of say 1400 to 1499

=SUMPRODUCT(--('[2010-01 Group Trial Balance.xls]Group Trial Balance -
Current'!$B$4:$B$278=$A68)*('[2010-01 Group Trial Balance.xls]Group Trial
Balance - Current'!$D$4:$BY$278))

Thanks

 

[Curtis]

Thx

I just noticed the final range wasn't a single column, so you might need this:

=SUMPRODUCT(($B$4:$B$278=$A68) * ($C$4:$C$278>=1400) * ($C$4:$C$278<1500),
$D$4:$BY$278))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.

Adding book reference/sheet references back in yourself, the syntax would be:

=SUMPRODUCT(--($B$4:$B$278=$A68),
--($C$4:$C$278>=1400), --($C$4:$C$278<1500),
$D$4:$BY$278))
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.

I currently use the formula below that works fine however I need to add in
another condition that only returns a value if the department number is in
the range of say 1400 to 1499

=SUMPRODUCT(--('[2010-01 Group Trial Balance.xls]Group Trial Balance -
Current'!$B$4:$B$278=$A68)*('[2010-01 Group Trial Balance.xls]Group Trial
Balance - Current'!$D$4:$BY$278))

Thanks