Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales data seperation
I am currently trying to graph specific data from several different
employees. these employees put their initals next to the sale information in a seperate coloumn but same row. I want to be able to pull the information from the rows by recognizing the initals that are put in. Can i get a little help if someone knows how to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales data seperation
an example might help here to help you understand what I am looking to do:
Initials: Sale amount ($) Quantity AA 500.00 1 BA 458.32 1 AA 1000.00 2 CA 546.55 1 AA 947.56 1 BA 625.36 1 If i wanted to add all of "AA"'s total sales amounts together and graph it, is there an easy way to have a formula recognize 'AA' in column A and add all the data for 'AA' in column B? "docbehr" wrote: I am currently trying to graph specific data from several different employees. these employees put their initals next to the sale information in a seperate coloumn but same row. I want to be able to pull the information from the rows by recognizing the initals that are put in. Can i get a little help if someone knows how to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales data seperation
Hi,
I would create a separate summary area using SUMIF(A$1:A$100,D1,B$1:B$100) I would put the formula into E1 and list all the Initials in D1:D10. Then I would plot the range E1:D10. -- If this helps, please click the Yes button Cheers, Shane Devenshire "docbehr" wrote: an example might help here to help you understand what I am looking to do: Initials: Sale amount ($) Quantity AA 500.00 1 BA 458.32 1 AA 1000.00 2 CA 546.55 1 AA 947.56 1 BA 625.36 1 If i wanted to add all of "AA"'s total sales amounts together and graph it, is there an easy way to have a formula recognize 'AA' in column A and add all the data for 'AA' in column B? "docbehr" wrote: I am currently trying to graph specific data from several different employees. these employees put their initals next to the sale information in a seperate coloumn but same row. I want to be able to pull the information from the rows by recognizing the initals that are put in. Can i get a little help if someone knows how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sales Order to Sales History Data | Excel Worksheet Functions | |||
Linking Sales Order to Sales History Data | Excel Worksheet Functions | |||
time seperation | Excel Worksheet Functions | |||
Text String Seperation. | Excel Worksheet Functions | |||
Seperation of prime and sub inventory units | Excel Worksheet Functions |