Still Looking
Posted by Manu on January 23, 2002 7:04 AM
Apologies for being repetitive,but I am hoping to find a way to do this:
What I have is Column A with values like 0.25, 0.56, 0.89 etc.. For each value in Col A there are respective values in Col B Col C & Col D, so for e.g. 0.25 125 564 236 is what a typical records looks like.
I need Excel to look at all values in Col A and then somehow add values in Col B Col C & Col D based on a rule that I define, say, Excel should look for all rows where A<1 and add up respective values from ColB, ColC & ColD
I tried your suggestion Juan(Thanks) but am getting #NAME? prompt.
Thanks for all your patience in bearing with me.
regards,
Posted by Joe Was on January 23, 2002 7:53 AM
Manu, The #NAME error indicates that you typed something wrong. A named range, a lable or text or a formula name. Juan's responce is correct and through a group of IF statements you should be able to get what you need.
=IF(A5<1,B5+C5+D5,0) Does what you need the formula cannot be in A5,B5,C5 or D5 it must be in its own cell! JSW
