Either LOOKUP or INDEX Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying to calculate the sum value from the column of one
worksheet to a cell in another worksheet (all in the same workbook). I have
tried the VLOOKUP function where I establish the look_up_value and compare it
to an array in the other worksheet. It works except that the value it returns
is the last cell in the array that meets the look up value. I want it to SUM
all the applicable cells in that column that meet the look up value.

Any suggestions would be greatly appreciated.

Thanks!
 
Have you looked at the SUMIF function?

e.g. =SUMIF(Sheet1!A2:A5,"g",Sheet1!B2:B5) will sum all values in range
B2:B5 on Sheet1 where the corresponding values in range A2:A5 are 'g'.
 
=SUMIF(A2:A100,H2,B2:B100)

where H2 is the criteria and B2:B100 is the range you want to sum where
A2:A100 equals H2


adapt to fit your own data accordingly

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup array formula problem 2
INDEX & MATCH find first column value in an array? 3
Using SUM + INDEX in array formula 5
Conditional Formulas 1
Scrabble Value calculation for Welsh words 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Match with 3 criteria 3
Excel Highlighting duplicates 0

Back
Top