How can I SUMIF between rows rather than columns?

[Robnarc]

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!

 

[Mike H]

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.

 

[Bernard Liengme]

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