Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
My problem is that I have a list of information and I need to lookup to parts of info. and then lookup a value. For example lookup cost centre, then sub-cost centre and then return that value.
I know there is a formula to do this, i have tried to SUMIF formula's but they don't seem to work.
Can anyone help ??
| Check out our Excel Resources | ||||
 |
 |
|||
not wishing to insult anyone intelligence.
sumif works like this
=sumif(the_range_you_want_to_test,what_you're_testing_for,the_range_you_need_to_SUM)
so
=sumif(A2:A7,"banana",B2:A7)
would add up anything in B2:B7 that is related to the word banana in A2:A7
if a table looked like this
Fruit Number
apple 20
pear 13
banana 4
apple 19
pear 12
banana 13
the formula would return 17 as the answer
Does this help??
Ian
Care to provide 10 t0 15 rows of your data along with the expect result(s)?
Aladin