Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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

Check out our Excel Resources

Re: SUMIF Problems

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


This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.