Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on formula

Status
Not open for further replies.
bbenaway

bbenaway

Instructor
Sep 19, 2002
18
0
0
=SUMPRODUCT((Production!D9:D28="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!D9:D28="Nancy")*Production!G9:G28,Z9:Z28)*5

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

Again, thanks in advance.
 
Sort by date Sort by votes

Hi,


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


Skip,
[sup][glasses]Don't let the Diatribe...
talk you to death![tongue][/sup][sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
101
TomSalvato
TomSalvato
cneill
  • Locked
  • Question
Hi, I need some help with Pre an
Replies
7
Views
106
SkipVought
S
navyasree
  • Locked
  • Question
Need to update excel on making changes in visio flowcharts 1
Replies
4
Views
112
Andrzejek
Andrzejek
zinderellie
  • Locked
  • Question
Excel 365- Formula Help - When A1=X and B1=Y, Return C1
Replies
8
Views
121
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top