Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array... Sort of...
Ok, I need to look through ONE column for a certain string of data and
if it exists I need to pull the value of the column to the right on the same row and sum them all together for a particular string. Is there an elegant way to do this? Thanks. J. |
#2
|
|||
|
|||
Array... Sort of...
Something like
=SUMIF(A:A,some_value,B:B) -- HTH RP (remove nothere from the email address if mailing direct) "Egon" wrote in message oups.com... Ok, I need to look through ONE column for a certain string of data and if it exists I need to pull the value of the column to the right on the same row and sum them all together for a particular string. Is there an elegant way to do this? Thanks. J. |
#3
|
|||
|
|||
Array... Sort of...
Egon wrote:
Ok, I need to look through ONE column for a certain string of data and if it exists I need to pull the value of the column to the right on the same row and sum them all together for a particular string. Is there an elegant way to do this? Thanks. J. Perhaps a simple illustration. It's really hard to figure out what you mean by "sum them all together". Sum *what* all together? Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Sort Function Without Using VBA | Excel Worksheet Functions | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |