If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
charting different tpes of lumber on a list. (SEE PIC)
http://www.digitaluprising.net/site/...l_untitled.JPG The above is a lumber list i am using... I have many different types of lumber in column "M" such at bms, sill, plate, studs, etc. I want to be able to graph the amount of boardfeet on each different ype of lumber. So basically i'm looking to auto sort and combine the different types to eventually have one bulk amount of bms, one bulk amount of plate, etc. The board footage is calculated on column "I" Thanks! You know, even if there is a way not to have to sort it, but just for it to recognize that all board footage in a row thats usage is sill, is to be different then all board footage under rows with plate. Thanks again fellas. Is this possible? -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
#2
|
|||
|
|||
you know, on second thought, i know this is charting, worksheet functions is my next stop. Anyway, i thought about it, and instead of sorting the list, are there cells i could create a functio in to sum the total numbers of the rows that have a certain type of lumber... like, sum of rows in colum "X" if column "y" = sill ??? and have it only add the rows with certain label. Thaks guys! -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
#3
|
|||
|
|||
The sumproduct function will work for you
=sumproduct(--(Y1:Y1000=A1),X1:X1000) if you have the product you want to sum up in A1 note in sumproduct you can't use entire columns Y1:Y10000 is OK, but Y:Y is not. and the arrays in eac section must be the same size. or you could use the Sumif function =sumif(Y:Y,"Sill",X:X) "foxgguy2005" wrote: you know, on second thought, i know this is charting, worksheet functions is my next stop. Anyway, i thought about it, and instead of sorting the list, are there cells i could create a functio in to sum the total numbers of the rows that have a certain type of lumber... like, sum of rows in colum "X" if column "y" = sill ??? and have it only add the rows with certain label. Thaks guys! -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
#4
|
|||
|
|||
This could be a job for a pivot table. Here's a brief intro on my site,
written by Debra Dalgleish: http://peltiertech.com/Excel/Pivots/pivotstart.htm and some links, which wouldn't have been included if they weren't helpful: http://peltiertech.com/Excel/Pivots/pivotlinks.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ foxgguy2005 wrote: you know, on second thought, i know this is charting, worksheet functions is my next stop. Anyway, i thought about it, and instead of sorting the list, are there cells i could create a functio in to sum the total numbers of the rows that have a certain type of lumber... like, sum of rows in colum "X" if column "y" = sill ??? and have it only add the rows with certain label. Thaks guys! |
#5
|
|||
|
|||
in terms of the sumif funtion, that will actually work great for my purposes. Now would there also be a way to extend that funtion to a large amount of sheets? I have sheets that start with 01, and can go all the way to 99. so would anyone happen to know a line i can add to "=SUMIF(M:M,"Sill",I:I)" to add up all the sheets? Thanks! -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
#6
|
|||
|
|||
*bump* -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
#7
|
|||
|
|||
flump -- foxgguy2005 ------------------------------------------------------------------------ foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663 View this thread: http://www.excelforum.com/showthread...hreadid=379939 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
test | test | General Discussion | 0 | November 23rd, 2004 12:09 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
finding & sorting unqiue names list | iwtci | Worksheet Functions | 6 | June 6th, 2004 06:43 AM |
How to make list of unique values? | JulieD | Worksheet Functions | 1 | February 26th, 2004 01:25 PM |