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!