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" <[email protected]> wrote in message
news:[email protected]...
> 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="Income"),C2:C20)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "nc" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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"?
> >
> >
> >
Bookmarks