Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply data in every 3rd row on a sheet
How do I multiply numbers from every 3rd cell in a worksheet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply data in every 3rd row on a sheet
Enter this array* formula
=PRODUCT(IF(LEN(ROW(A2:A100)/3)=1,A2:A100,"X")) Adjust range location/size as desired. *Use Ctrl+Shift+Enter to confirm formula -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Elsmith" wrote: How do I multiply numbers from every 3rd cell in a worksheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply data in every 3rd row on a sheet
Say in A1 thru A21 we have:
16 16 22 27 14 11 4 1 9 1 3 24 6 5 24 28 30 4 18 7 28 and we want to multiply every third row by 7 (that is rows 1, 4,7,...). In B1 thru B3 enter: 7 1 1 Copy B1 thru B3 and paste to B4 thru B21. In C1 enter: =A1*B1 and copy down. We see: 16 7 112 16 1 16 22 1 22 27 7 189 14 1 14 11 1 11 4 7 28 1 1 1 9 1 9 1 7 7 3 1 3 24 1 24 6 7 42 5 1 5 24 1 24 28 7 196 30 1 30 4 1 4 18 7 126 7 1 7 28 1 28 So every third row has been multiplied by 7. -- Gary''s Student - gsnu200843 "Elsmith" wrote: How do I multiply numbers from every 3rd cell in a worksheet? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply data in every 3rd row on a sheet
In article ,
Elsmith wrote: How do I multiply numbers from every 3rd cell in a worksheet? To sum every 3rd cell in A2:A100, starting with the first cell in the range, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER... =PRODUCT(IF(A2:A100<"",IF(MOD(ROW(A2:A100)-ROW(A2)+0,3)=0,A2:A100))) To sum every 3rd cell, starting with the first occurrence of nth, replace... +0 with +1 Hope this helps! http://www.xl-central.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cross-multiply text data in excel?? | Excel Discussion (Misc queries) | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
How do I multiply the whole sheet by a number | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |