![]() |
#13
|
|||
|
|||
![]()
[@FieldName] is used in Table formula syntax only - you can't use it outside of defined Table!
When you have numbers in cells A2 and B2 (and column headers in row 1), and you want sum of those numbers, then: 1. Without a Table defined, you can e.g. in cell C2 (i.e. in same row for this example) use formulas Code:
= $A2 + $B2 or = SUM($A2,$B2) or =SUM($A2:$B2) Code:
=[@ColAName] + [@ColBName] or =SUM([@ColAName],[@ColBName]) or =SUM([[@ColAName]:[@ColBName]]) or = $A2 + $B2 or = SUM($A2,$B2) or =SUM($A2:$B2) Named ranges mostly are useful when you need calculations over range. Of-course you can define also a dynamic named ranges to imitate common Excel formulas behavior, but with current example I don't see any reason for this. An example anyway: Select any cell in row 2. Define a name eg. Code:
dnMyRange =Results!$A2:$B2 Now into column sum into cell E2 (or into any cell in row 2, even on different worksheet) enter formula Code:
=SUM(dnMyRange) |
Tags |
named ranges |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
SavGDK | Excel | 5 | 05-01-2017 09:41 AM |
![]() |
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |
Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |