sum if based on a defined range

A

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
 
C

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
 
A

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
 
I

isabelle

hi Angus,

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

--
isabelle



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top