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.
Am Fri, 4 May 2012 02:54:07 -0700 (PDT) schrieb Angus Beaumont:
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.
Le 2012-05-04 09:23, Angus Beaumont a ?crit :
thanks for your help Isabelle