Sum values in columns based on values in named range
Thanks again, this is another helpful solution.
gone from none to 2 working solutions in one day!
i really appreciate this,
BR
Mikael
"vezerid" wrote:
=SUMPRODUCT(G1:G100;--(COUNTIF(People;D1:D100)<0))
My guess is you don't need to replace ; with ,. You probably have
settings that list separator is the ;.
HTH
Kostis Vezerides
On Nov 11, 12:51 pm, Mikael Andersson
wrote:
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
|