Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add certain cells based on a function
I have a column of data with several hundred rows. I want to add every other row and show the results in another cell. How would i go about doing this? How about if i wanted to add every 2nd and 3rd row? Is there a function i can use to do this? In other words: 1 2 3 4 5 6 7 8 9 10 I want to sum up the (2+3) then skip a row (5+6) skip another row (8+9) etc. -- MrSandman ------------------------------------------------------------------------ MrSandman's Profile: http://www.excelforum.com/member.php...fo&userid=7826 View this thread: http://www.excelforum.com/showthread...hreadid=520860 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add certain cells based on a function
=SUM(IF(MOD(ROW($A$10:$A$19),$B$20)=0,$A$10:$A$19, 0)) this is an array formula you will need to controll shift enter for it to work $B$20 is the Nth value you want Add every other number input 2 etc. -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=520860 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |