Excel - sum if based on a defined range

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

Hi Angus,

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


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


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks but that did not 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

hi Angus,

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

--
isabelle



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

thanks for your help Isabelle