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 ??
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
Posted by Aladin Akyurek on July 24, 2001 7:09 AM
Request
Marc,
Care to provide 10 t0 15 rows of your data along with the expect result(s)?
Aladin
