MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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