>> As I see you must define each item. You could use a different formula, but I >> don't think, it would be "better": >> =SUM(A2:C2)*(A1=3)+SUM(A2:B2)*(A1=2)+A2*(A1=1)
Claudia, I had no idea the formula could be this simple. I noticed that it doesn't even matter in what order you put the different summaries. That is something that would be crucial in the example I gave. Arnold Huzen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
