Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying across then total down
I need a formula to multiply f1:f4*a1:a4 then to total that number at the
end of the column in f5. Since there is also text in this column I just want it to reconize the numbers. Example of table below: This is what my sad attempt looks like in cell f5: =sum(f1*a1+f2*a2+f3*a3+f4*a4) Which does work until I get to the text. A B C D E F 10% 15.58 38.50 26.68 9.43 N/A 10% 13.51 36.03 24.85 6.41 3.34 4% 8.41 28.66 20.26 4.86 N/A 4% 3.67 1 3.86 15.75 9.89 9.20 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying across then total down
I believe you want
=SUMPRODUCT((A1:A4),(F1:F4)) "sweetsue516" wrote: I need a formula to multiply f1:f4*a1:a4 then to total that number at the end of the column in f5. Since there is also text in this column I just want it to reconize the numbers. Example of table below: This is what my sad attempt looks like in cell f5: =sum(f1*a1+f2*a2+f3*a3+f4*a4) Which does work until I get to the text. A B C D E F 10% 15.58 38.50 26.68 9.43 N/A 10% 13.51 36.03 24.85 6.41 3.34 4% 8.41 28.66 20.26 4.86 N/A 4% 3.67 1 3.86 15.75 9.89 9.20 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying across then total down
Using your sample data I got the result 0.702 using this formula in F5:
=SUMPRODUCT(F1:F4,A1:A4) Will that do it for you? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Multiplying a # in a cell to total an $ in another cell | New Users to Excel | |||
matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions |