sum if based on a defined range

[Angus Beaumont]

I am struggling to get the correct syntax for a sumif where I want to
sum the contents of column H where the contents of Column A is
included in my named range "Channels". i.e. if in column A the names
do not appear in my range channels I do not want to sum in column H.

thanks

 

[Claus Busch]

Hi Angus,

Am Fri, 4 May 2012 02:54:07 -0700 (PDT) schrieb Angus Beaumont:

I am struggling to get the correct syntax for a sumif where I want to
sum the contents of column H where the contents of Column A is
included in my named range "Channels". i.e. if in column A the names
do not appear in my range channels I do not want to sum in column H.

try:
=SUM(OFFSET(Channels,,7))


Regards
Claus Busch

 

[Angus Beaumont]

Hi Angus,

Am Fri, 4 May 2012 02:54:07 -0700 (PDT) schrieb Angus Beaumont:


try:
=SUM(OFFSET(Channels,,7))

Regards
Claus Busch

Thanks but that didn't work
in column A the user will input CHannel names validated from a range
called "Channels". In row H is a budget which I want to sum only where
there is a validated channel in column A. hope that makes sense.

Angus

 

[isabelle]

hi Angus,

=SUMPRODUCT(--(NOT(ISERROR(MATCH(A1:A100,Channels,0))))*(H1:H100))

--
isabelle



Le 2012-05-04 09:23, Angus Beaumont a écrit :

 

[Angus Beaumont]

hi Angus,

=SUMPRODUCT(--(NOT(ISERROR(MATCH(A1:A100,Channels,0))))*(H1:H100))

thanks for your help Isabelle