Then add one more column that sums across the row, then use one of Bob's
SUMIF() functions and reference the new column

"nc" wrote:

Thanks Bob.

I have about 10 columns. I was looking for a symplified function.

"Bob Phillips" wrote:

=sumif(A2:A20="Income"),B2:B20)+sumif(A2:A20="Inco me"),C2:C20)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in message
...
EENF EPDA EKHC GGEN
Expenditure 1 2 3 4
Income 2 2 2 6
Capital additions 5 2 4 5
Income 7 8 9 5
Capital additions 10 11 12 11

How can I total the more than one column if the criteria is "Income"?