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
would add up anything in B2:B7 that is related to the word banana in A2:A7
if a table looked like this
the formula would return 17 as the answer
Does this help??
Care to provide 10 t0 15 rows of your data along with the expect result(s)?