Tutorial :How do I reference a “subset” or cells in an Excel Named Range?


I have a named range in Excel (that was created do to making a Web Query in Excel)... how do I get the sum of just the "Amount" column?

Example: This works: =SUM(MyRange)

The problem is, that sums EVERY numeric looking field (so "Amount" and "UserID" are BOTH being included in the SUM function).

What I need is this: =SUM(MyRange["Amount"]) ... but I can't seem to find how to do something like that.



Try this: The DSUM formula (Database SUM):


Basically, it's just summing the 'Amount' field in the database 'MyRange'.



You could use the offset() function if you know where the Amount column is relative to the named range.

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »