Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple formula help in Excel 2007
I need to multiply two cells with numbers, then add that to two cells with
numbers that multiply each other, then add that to two cells that multiply each other. In simpler times, in the past with Excel 2003, I believe I achieved that by using the following. Can you correct me for Excel 2007? =SUM(A1*A10)+(B1*B10)+(C1*C10) Thank you... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple formula help in Excel 2007
You don't really need the SUM function. This should accomplish what you want:
=(A1*A10)+(B1*B10)+(C1*C10) Even the parenthesis are technically redundant and could be removed, but I would include them anyway just because it's easier to read. HTH Elkar "Dave V" wrote: I need to multiply two cells with numbers, then add that to two cells with numbers that multiply each other, then add that to two cells that multiply each other. In simpler times, in the past with Excel 2003, I believe I achieved that by using the following. Can you correct me for Excel 2007? =SUM(A1*A10)+(B1*B10)+(C1*C10) Thank you... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple formula help in Excel 2007
Try it like this:
=SUMPRODUCT(A1:C1,A10:C10) -- Biff Microsoft Excel MVP "Dave V" <Dave wrote in message ... I need to multiply two cells with numbers, then add that to two cells with numbers that multiply each other, then add that to two cells that multiply each other. In simpler times, in the past with Excel 2003, I believe I achieved that by using the following. Can you correct me for Excel 2007? =SUM(A1*A10)+(B1*B10)+(C1*C10) Thank you... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Macro to do a simple cut/paste operation. | Excel Discussion (Misc queries) | |||
why doesn't this simple macro work in excel 2007? | Excel Discussion (Misc queries) | |||
Simple % deduciton in excel 2007 | Excel Discussion (Misc queries) | |||
Simple links in Excel 2007 | Excel Worksheet Functions | |||
Simple way to enable just my personal macros in Excel (& Office) 2007 | New Users to Excel |