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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I add different ranges in a column together?
I have a large column of numbers and need to select random numbers that I
need to total. Rather than adidng one cell at a time. How do I add multiple ranges within the column together? Thank you |
#2
|
|||
|
|||
How do I add different ranges in a column together?
If they're ranges (as in groups of consecutive cells) you can use SUM, as in
=sum(a1:a5,a20:a43, ... ). If they're cells that are selected based on the value of some other cell in the same row, you can use sumif: =sumif(b:b,"Selection",a:a) would add the values in column A of the rows where column B is equal to "Selection". If it's really pretty random, I'd introduce a 'helper' column. Fill that helper column either with various values ("Project A", "Project B", etc) to use with the sumif as above. Or just enter 1's for the group you wish to select, then use =sumproduct(a:a,b:b); if column B has 1's for the rows you want to include, this would add up all the corresponding entries from column A. HTH. --Bruce "Jackie" wrote: I have a large column of numbers and need to select random numbers that I need to total. Rather than adidng one cell at a time. How do I add multiple ranges within the column together? Thank you |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
How to group similar column titles together???? | vrk1 | General Discussion | 2 | April 30th, 2005 12:17 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Creating multi Column Date Ranges using Now/Date ?? | BruceG | New Users | 3 | March 25th, 2005 10:13 PM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |