| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement using rows and columns
i have a chart that auto-populates Mat'l, Diameter, and length.
the mat'l can be mat'l1, matl2, or matl3 the diameter can be 1,1.5,2,2.5....all the way to 10 how can i calculate the total length of each matl at each diameter? my chart looks like Mat'l | Diameter | Length 1 1 10 1 1 175 2 1.5 55 and so on. so i want to show Matl1 ø1 has a total length of 175 Matl2 ø1.5 has a total length of 55 and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
Threaded Mode
