How can I add the values in a column according to values in another
column? If there is any value in a row in column B, I want to include
the value of the corresponding row in column A. I'm flexible as to
whether this is ANY value (i.e. not empty) or greater than zero.

Hi Paul
Maybe something like this =IF(B1="","",IF(B1>0,B1+A1))
Regards
Cimjet
"Paul Kaye" <(E-Mail Removed)> wrote in message
news:05befaf3-9ba8-48c8-aebb-(E-Mail Removed)...
> How can I add the values in a column according to values in another
> column? If there is any value in a row in column B, I want to include
> the value of the corresponding row in column A. I'm flexible as to
> whether this is ANY value (i.e. not empty) or greater than zero.

=SUMPRODUCT(A1:A100,--(B1:B100<>"")) adjust the range to suit.
--
Gary''s Student - gsnu2007j


"Paul Kaye" wrote:

> How can I add the values in a column according to values in another
> column? If there is any value in a row in column B, I want to include
> the value of the corresponding row in column A. I'm flexible as to
> whether this is ANY value (i.e. not empty) or greater than zero.
>

On Jul 10, 3:04*pm, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> =SUMPRODUCT(A1:A100,--(B1:B100<>"")) adjust the range to suit.
> --
> Gary''s Student - gsnu2007j
>
> "Paul Kaye" wrote:
> > How can I add the values in a column according to values in another
> > column? If there is any value in a row in column B, I want to include
> > the value of the corresponding row in column A. I'm flexible as to
> > whether this is ANY value (i.e. not empty) or greater than zero.

What does the -- and <> do? I really don't understand that formula!

On Jul 10, 2:49*pm, "Cimjet" <cimjet(remove)3...@sympatico.ca> wrote:
> Hi Paul
> Maybe something like this =IF(B1="","",IF(B1>0,B1+A1))
> Regards
> Cimjet"Paul Kaye" <paulmjk...@gmail.com> wrote in message
>
> news:05befaf3-9ba8-48c8-aebb-(E-Mail Removed)...
>
> > How can I add the values in a column according to values in another
> > column? If there is any value in a row in column B, I want to include
> > the value of the corresponding row in column A. I'm flexible as to
> > whether this is ANY value (i.e. not empty) or greater than zero.

The trouble is that it needs to refer to all the rows in a range.

On Jul 10, 5:41*pm, Paul Kaye <paulmjk...@gmail.com> wrote:
> On Jul 10, 3:04*pm, Gary''s Student
>
> <GarysStud...@discussions.microsoft.com> wrote:
> > =SUMPRODUCT(A1:A100,--(B1:B100<>"")) adjust the range to suit.
> > --
> > Gary''s Student - gsnu2007j
>
> > "Paul Kaye" wrote:
> > > How can I add the values in a column according to values in another
> > > column? If there is any value in a row in column B, I want to include
> > > the value of the corresponding row in column A. I'm flexible as to
> > > whether this is ANY value (i.e. not empty) or greater than zero.
>
> What does the -- and <> do? I really don't understand that formula!

Sorry Gary's Student - I forgot to say that it worked perfectly, I
just can't understand why!!! Could you give me a brief description?

It just means "not equal to"
--
Gary''s Student - gsnu2007j


"Paul Kaye" wrote:

> On Jul 10, 5:41 pm, Paul Kaye <paulmjk...@gmail.com> wrote:
> > On Jul 10, 3:04 pm, Gary''s Student
> >
> > <GarysStud...@discussions.microsoft.com> wrote:
> > > =SUMPRODUCT(A1:A100,--(B1:B100<>"")) adjust the range to suit.
> > > --
> > > Gary''s Student - gsnu2007j
> >
> > > "Paul Kaye" wrote:
> > > > How can I add the values in a column according to values in another
> > > > column? If there is any value in a row in column B, I want to include
> > > > the value of the corresponding row in column A. I'm flexible as to
> > > > whether this is ANY value (i.e. not empty) or greater than zero.
> >
> > What does the -- and <> do? I really don't understand that formula!
>
> Sorry Gary's Student - I forgot to say that it worked perfectly, I
> just can't understand why!!! Could you give me a brief description?
>

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html



Paul Kaye wrote:
>
> On Jul 10, 3:04 pm, Gary''s Student
> <GarysStud...@discussions.microsoft.com> wrote:
> > =SUMPRODUCT(A1:A100,--(B1:B100<>"")) adjust the range to suit.
> > --
> > Gary''s Student - gsnu2007j
> >
> > "Paul Kaye" wrote:
> > > How can I add the values in a column according to values in another
> > > column? If there is any value in a row in column B, I want to include
> > > the value of the corresponding row in column A. I'm flexible as to
> > > whether this is ANY value (i.e. not empty) or greater than zero.
>
> What does the -- and <> do? I really don't understand that formula!

--

Dave Peterson