| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I sum data on a row from certain named columns?
I have a list of products on columns with the materials correspondence (on
rows). At each product I have more 2 columns that shows me how many of each material I need for producing a number of products. The same material is used by another product, so I need to sum the material needs only for the "Total" named columns of each product. This means I have to sum every third column's cell by row. Can anyone give me some help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I sum data on a row from certain named columns?
Hi!
Assume you want to sum cells A1, D1, G1 and J1. Since that's not a very big range I would just use: =SUM(A1,D1,G1,J1) If you have a larger range, every 3rd cell from A1 to BA1: =SUMPRODUCT(--(MOD(COLUMN(A1:BA1),3)=1),A1:BA1) Biff "Liliana" wrote in message ... I have a list of products on columns with the materials correspondence (on rows). At each product I have more 2 columns that shows me how many of each material I need for producing a number of products. The same material is used by another product, so I need to sum the material needs only for the "Total" named columns of each product. This means I have to sum every third column's cell by row. Can anyone give me some help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
