Prev: Capturing Real Time Data
Next: how to undo scrolling tied to a single cell
From: Robnarc on 23 Feb 2010 06:47
I need to sum the values in one row, but only if the corresponding values in
a second row fulfil a criteria.

e.g. With a budget laid out with a column for each month in 2010: for each
month sum "Cost A" if "Income type 1" > 0.

Thanks!
From: Mike H on 23 Feb 2010 06:55
Hi,

From your description I'm struggling to undertsnad you data layout but maybe
this

=SUMIF(A2:L2,">0",A1:L1)

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Robnarc" wrote:

> I need to sum the values in one row, but only if the corresponding values in
> a second row fulfil a criteria.
>
> e.g. With a budget laid out with a column for each month in 2010: for each
> month sum "Cost A" if "Income type 1" > 0.
>
> Thanks!
From: Bernard Liengme on 23 Feb 2010 07:36
Mike,
The OP is looking for missing names in column B but present in A, you neat
method seems to locate names missing in column A compared to B
best wishes
Bernard

"Mike H" <MikeH(a)discussions.microsoft.com> wrote in message
news:2A7E0CC1-0173-4702-87FF-5A4156C3BCA5(a)microsoft.com...
> Hi,
>
> From your description I'm struggling to undertsnad you data layout but
> maybe
> this
>
> =SUMIF(A2:L2,">0",A1:L1)
>
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Robnarc" wrote:
>
>> I need to sum the values in one row, but only if the corresponding values
>> in
>> a second row fulfil a criteria.
>>
>> e.g. With a budget laid out with a column for each month in 2010: for
>> each
>> month sum "Cost A" if "Income type 1" > 0.
>>
>> Thanks!

 | 
Pages: 1
Prev: Capturing Real Time Data
Next: how to undo scrolling tied to a single cell