| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of 2 columns * 3rd column
I'm using Excel 2007 and can't figure out how to enter the following formula:
(A3 + B3) * G3 (number in A3 PLUS number in B3) MULTIPLIED by number in column G3 Any help would be greatly appreciated. I did this in Excel XP, but haven't figured it out for Excel 2007. TIA -- Gaye |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of 2 columns * 3rd column
Put this in any cell except a3, b3 and g3:
=(A3 + B3) * G3 (I just added an equal sign) Gaye wrote: I'm using Excel 2007 and can't figure out how to enter the following formula: (A3 + B3) * G3 (number in A3 PLUS number in B3) MULTIPLIED by number in column G3 Any help would be greatly appreciated. I did this in Excel XP, but haven't figured it out for Excel 2007. TIA -- Gaye -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of 2 columns * 3rd column
You were close..........just forgot the "=" sign
=(A3+B3)*G3 entered in a cell. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 18:02:00 -0800, Gaye (donotspam) wrote: I'm using Excel 2007 and can't figure out how to enter the following formula: (A3 + B3) * G3 (number in A3 PLUS number in B3) MULTIPLIED by number in column G3 Any help would be greatly appreciated. I did this in Excel XP, but haven't figured it out for Excel 2007. TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Column in to 2 columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| How to add one column if 2 other columns have a specific value | Excel Worksheet Functions | |||
| formula - sum "x" column L only when same row contains "y" columns | Excel Worksheet Functions | |||
Linear Mode
