Here is a formula with a few columns, add the rest

=SUMPRODUCT(--(A2:A20="Income"),B2:B20+C2:C20+D2:D20)

--

HTH

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


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