MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SUMIF Problems

Posted by Marc Bentley on July 23, 2001 5:46 AM


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 ??

Posted by Ian on July 23, 2001 6:10 AM

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

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??


Posted by Aladin Akyurek on July 24, 2001 7:09 AM



Care to provide 10 t0 15 rows of your data along with the expect result(s)?