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
Hi,

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

=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



Request

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

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

Aladin


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.