shades
Well-known Member
- Joined
- Mar 20, 2002
- Messages
- 1,550
I have a table (labeled "Corp") $A$3:$J$196.
Column A is City
Column B is Company
Columns C-I are spending subtotals
Column J is the sum of Columns C-I
I am trying to set up a DSUM to show the spending for a company across the various cities.
In cell M6 I have put this formula:
=DSUM(Corp,J3:J196,CritRange)
where CritRange is a named range ($M$3) in which I type the company name.
However, no matter what I enter into M3 I receive the notice:
"#Value!"
What am I doing wrong?
Any help would be much appreciated.
_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-04-10 12:53
Column A is City
Column B is Company
Columns C-I are spending subtotals
Column J is the sum of Columns C-I
I am trying to set up a DSUM to show the spending for a company across the various cities.
In cell M6 I have put this formula:
=DSUM(Corp,J3:J196,CritRange)
where CritRange is a named range ($M$3) in which I type the company name.
However, no matter what I enter into M3 I receive the notice:
"#Value!"
What am I doing wrong?
Any help would be much appreciated.
_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-04-10 12:53