How can I SUMIF between rows rather than columns?

  • Thread starter Thread starter Robnarc
  • Start date Start date
R

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!
 
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.
 
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
 
Back
Top