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.