A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

charting different tpes of lumber on a list. (SEE PIC)



 
 
Thread Tools Display Modes
  #1  
Old June 17th, 2005, 02:00 AM
foxgguy2005
external usenet poster
 
Posts: n/a
Default 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  
Old June 17th, 2005, 02:40 AM
foxgguy2005
external usenet poster
 
Posts: n/a
Default


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  
Old June 17th, 2005, 04:00 PM
bj
external usenet poster
 
Posts: n/a
Default

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  
Old June 18th, 2005, 12:00 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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  
Old June 18th, 2005, 04:43 PM
foxgguy2005
external usenet poster
 
Posts: n/a
Default


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  
Old June 21st, 2005, 02:43 PM
foxgguy2005
external usenet poster
 
Posts: n/a
Default


*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  
Old June 24th, 2005, 03:16 AM
foxgguy2005
external usenet poster
 
Posts: n/a
Default


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.