Need help on formula

[bbenaway]

=SUMPRODUCT((Production!D928="Nancy")*Production!G9:G28)*5

Am using the formula above and want to extend the search area to another column. Am adding column Z9:Z28 in the following way.

=SUMPRODUCT((Production!D928="Nancy")*Production!G9:G28,Z9:Z28)*5

However, the formula does not work, what am I doing wrong.

Again, thanks in advance.

 

[SkipVought]

Hi,


[tt]
=SUMPRODUCT((Production!D928="Nancy")*Production!G9:G28)*5+SUMPRODUCT((Production!D928="Nancy")*Production!Z9:Z28)*5
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}