| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating with named ranges
if I have a range named "Quantities" in cells C3:O3 and a range named
"UnitPrice" in cells C5:O5, can I enter formulas in each of cells C7:O7 that use the range names to perform the multiplications of cells C3 * C5, D3 * D5, etc ? |
|
#2
|
|||
|
|||
|
Hi KG
in C7 the formula would be =Quantities*UnitPrice and then just drag it across to O7. Cheers JulieD "KG" wrote: if I have a range named "Quantities" in cells C3:O3 and a range named "UnitPrice" in cells C5:O5, can I enter formulas in each of cells C7:O7 that use the range names to perform the multiplications of cells C3 * C5, D3 * D5, etc ? |
|
#3
|
|||
|
|||
|
I wish I had asked this question years ago! Thanks JulieD
"KG" wrote: if I have a range named "Quantities" in cells C3:O3 and a range named "UnitPrice" in cells C5:O5, can I enter formulas in each of cells C7:O7 that use the range names to perform the multiplications of cells C3 * C5, D3 * D5, etc ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Discussion (Misc queries) | |||
| Poor Workbook Performance due to Named Ranges | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
