Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range of values
one way would be to select a column with the brands
then (Excel 2003) Data-Filter-Advanced Filter-Copy to other location (define yr criteria range)-Select Unique records only HIH On 7 Maj, 10:52, willemeulen wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range of values
Understand what youre saying but this will be manual, my goal is to automate
it so the sheet automatically gives the user a summary of the sheet. Like the example; unique brands and amounts sold. The original column must remain. "Jarek Kujawa" wrote: one way would be to select a column with the brands then (Excel 2003) Data-Filter-Advanced Filter-Copy to other location (define yr criteria range)-Select Unique records only HIH On 7 Maj, 10:52, willemeulen wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range of values
Hi,
Create a summary sheet, Let's assume your information is in sheet1, create another tab called Summary, and in column A enter the brands starting in row 1. I suppose that in Sheet 1 the brands are in column A and the total sold is in Column B, so in column B from the summary sheet enter the formula as follow =sumproduct(--(a1=sheet1!a:a),sheet1!b:b) If you are not using excel 2007 enter the formula as follow =sumproduct(--(a1=sheet1!$a$1:$a$1000),sheet1!$b$1:$b$1000) Hope this help "willemeulen" wrote: Understand what youre saying but this will be manual, my goal is to automate it so the sheet automatically gives the user a summary of the sheet. Like the example; unique brands and amounts sold. The original column must remain. "Jarek Kujawa" wrote: one way would be to select a column with the brands then (Excel 2003) Data-Filter-Advanced Filter-Copy to other location (define yr criteria range)-Select Unique records only HIH On 7 Maj, 10:52, willemeulen wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Sum values in columns based on values in named range | Excel Worksheet Functions | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) |