Posted to microsoft.public.excel.worksheet.functions
|
|
Sum values in columns based on values in named range
Hi,
I apologise, I misunderstood your question. You may also try to use the
DSUM function for this.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Mikael Andersson" wrote in
message ...
Hi, and thanks for your time. I´m familiar with the sumif function, the
problem seems to be the multiple criteria that exists in the range. I need
to
base the sumif on the range instead of hardcoding the criteria (easy).
br
mikael
"Ashish Mathur" wrote:
Hi,
You can use SUMIF() since you want to sum based in one criteria. Please
read up on the SUMIF() function in the Help menu - Good example there.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Mikael Andersson" wrote in
message ...
Thanks for a quick reply. However, it did not solve my problem. I´m
using
excel 2007 (separates criteria with ';'), should have mentioned that,
and
maybe i should explain further;
As i have understood it, the Range refers to the cells I want
evaluated,
criteria should be any of the values in ny named range, and Sum_range
refers
to the cells to sum if criteria is met?
Can i not use sumif?
Br
Mikael
"Ashish Mathur" wrote:
Hi,
Please correct for the following:
1. Replace ; with ,
2. Please check the syntax - it should be
=sumif(range,criteria,sum_range).
3. Looks like the range should be People. Please ensure that People
is
only
1 column wide.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Mikael Andersson" wrote
in
message ...
Hi,
hopefully i´m not in the wrong place to ask this.
I have a worksheet with a named range (people) currently 6 values
there,
one
column with lots of different values (Col D), and another column
with
numbers
(Col G). What i want to do is to sum values in Col G based on if Col
D
contains any of the values in the named range "People".
tried SUMIF(D:D;people;G:G) and such, but i cant figure it out.
I´m probably just too stupid to see the obvious, but i really need
help.
Best regards,
Mikael
|