How to nest SUM function in LOOKUP function?

  • Thread starter Thread starter frank6
  • Start date Start date
F

frank6

Anyone,

Am trying to lookup criteria (cost center) in a source workbook an
link return results (numbers two columns to

right) to a destination workbook. If the criteria repeats in the sourc
workbook, I want the formula to add the

numbers (two columns to the right) so that the return results in th
destination cell will be a summed figure.

Help! I can't seem to find the right nested formula!! Here's what
have so far, and it's doubling the return

results because my test criteria repeats two times. (I assume if i
repeated 3 times it would triple it.)

=LOOKUP(988,'[CARS Tracking 2004 Q2-Q4 3-15-04.xls]ADC CMTS CAR
Q2'!$C$5:$C$17,'[CARS Tracking 2004 Q2-Q4 3-15-04.xls]ADC CMTS CAR
Q2'!$E$5:$E$17)

I know the solution is simple and it's driving me loco
 
Hi
have a look at SUMIF. e.g.
=SUMIF('sheet1'!A1:A100,988,'sheet1'!C1:C100)
change the ranges to your needs
 
Back
Top