Thread: Range of values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
willemeulen willemeulen is offline
external usenet poster
 
Posts: 27
Default Range of values

It there any way I can summarize the range of values from a column. The
column contains manny repeats of values, let say car brand etc I want to
summarize the totals per brand at the bottom. I am using the sumif functions
to get the total numbers but how can I automatically show all the brands of
the sheet.