Try this:

=SUMPRODUCT(--(A1:A5="Provider name"),D1:D5+H1:H5+K1:K5+M1:M5+R1:R5+Z1:Z5)

Note: you can't use entire columns as range references in SUMPRODUCT unless
you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"Theo Degr" wrote in message
...
I have a large spreadhseet with multiple columns. In column a are vendor
names and in column B are their different programs. I would like to toatl
each program in column a. The issue that I am having is that the numbers
to
total are in columns d, h, k, m, r, and z.

The Sumif formula that I am using looks like this:

=+Sumif(A:A,"=Provider Name",D:D)
This of course gives me the total of column d for each provider. How do I
include the other columns or do I need to retype this formula for each
column
that I want to sum?

Any help would be appreciated.

Thanks
Ted