How can I SUMIF between rows rather than columns?
 

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!

How can I SUMIF between rows rather than columns?
 

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!

How can I SUMIF between rows rather than columns?
 

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" wrote in message
...
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!