Thread: Sumif Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Theo Degr Theo Degr is offline
external usenet poster
 
Posts: 17
Default Sumif Function

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