Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
I have 3 columns and 3 rows:
A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
Not sure what you mean by:
but I don't want to type it out... just drag and fill? sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3) This formula does the same thing as the one above: =SUMPRODUCT(A1:C1+A2:C2,A3:C3) -- Biff Microsoft Excel MVP "Melissa" wrote in message ... I have 3 columns and 3 rows: A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
My apologies for the unintelligible message and my thanks for your
suggestion. In reality, my formula is more complex than the one given. What I'm actually looking for is this: E f(x) (where E is the "sum of" symbol) So, I need to specify what f(x) is, and apply that across my columns. Instead of =sum(no.1, no.2, no.3, etc.), I would like =sum(f(x1), f(x2), f(x3), etc.) I hope this makes more sense... "T. Valko" wrote: Not sure what you mean by: but I don't want to type it out... just drag and fill? sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3) This formula does the same thing as the one above: =SUMPRODUCT(A1:C1+A2:C2,A3:C3) -- Biff Microsoft Excel MVP "Melissa" wrote in message ... I have 3 columns and 3 rows: A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
Sorry, not following you on this.
-- Biff Microsoft Excel MVP "Melissa" wrote in message ... My apologies for the unintelligible message and my thanks for your suggestion. In reality, my formula is more complex than the one given. What I'm actually looking for is this: E f(x) (where E is the "sum of" symbol) So, I need to specify what f(x) is, and apply that across my columns. Instead of =sum(no.1, no.2, no.3, etc.), I would like =sum(f(x1), f(x2), f(x3), etc.) I hope this makes more sense... "T. Valko" wrote: Not sure what you mean by: but I don't want to type it out... just drag and fill? sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3) This formula does the same thing as the one above: =SUMPRODUCT(A1:C1+A2:C2,A3:C3) -- Biff Microsoft Excel MVP "Melissa" wrote in message ... I have 3 columns and 3 rows: A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
I realised I was overcomplicating things and using sumproduct works
perfectly. I just need to be extra careful in defining the ranges in the formula. Thank you very much for that tip and sorry again for the confusion. "T. Valko" wrote: Sorry, not following you on this. -- Biff Microsoft Excel MVP "Melissa" wrote in message ... My apologies for the unintelligible message and my thanks for your suggestion. In reality, my formula is more complex than the one given. What I'm actually looking for is this: E f(x) (where E is the "sum of" symbol) So, I need to specify what f(x) is, and apply that across my columns. Instead of =sum(no.1, no.2, no.3, etc.), I would like =sum(f(x1), f(x2), f(x3), etc.) I hope this makes more sense... "T. Valko" wrote: Not sure what you mean by: but I don't want to type it out... just drag and fill? sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3) This formula does the same thing as the one above: =SUMPRODUCT(A1:C1+A2:C2,A3:C3) -- Biff Microsoft Excel MVP "Melissa" wrote in message ... I have 3 columns and 3 rows: A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum up a range of formulas?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Melissa" wrote in message ... I realised I was overcomplicating things and using sumproduct works perfectly. I just need to be extra careful in defining the ranges in the formula. Thank you very much for that tip and sorry again for the confusion. "T. Valko" wrote: Sorry, not following you on this. -- Biff Microsoft Excel MVP "Melissa" wrote in message ... My apologies for the unintelligible message and my thanks for your suggestion. In reality, my formula is more complex than the one given. What I'm actually looking for is this: E f(x) (where E is the "sum of" symbol) So, I need to specify what f(x) is, and apply that across my columns. Instead of =sum(no.1, no.2, no.3, etc.), I would like =sum(f(x1), f(x2), f(x3), etc.) I hope this makes more sense... "T. Valko" wrote: Not sure what you mean by: but I don't want to type it out... just drag and fill? sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3) This formula does the same thing as the one above: =SUMPRODUCT(A1:C1+A2:C2,A3:C3) -- Biff Microsoft Excel MVP "Melissa" wrote in message ... I have 3 columns and 3 rows: A1 B1 C1 A2 B2 C2 A3 B3 C3 In row 4, i have the formula: (A1+A2)*A3 which is applied to columns B and C Is there a formula which allows me to sum up row 4 without first obtaining the values by columns A, B and C? i.e. something like: sum((A1+A2)*A3,(B1+B2)*B3,(C1+C2)*C3)... but I don't want to type it out... just drag and fill? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel range formulas | Excel Worksheet Functions | |||
Formulas in a range of cells | Excel Worksheet Functions | |||
How do you set up range names, name formulas | Excel Worksheet Functions | |||
How to find all formulas that used a certain named range | Excel Discussion (Misc queries) | |||
Protecting Formulas from a range from being viewed | Excel Discussion (Misc queries) |