Pulling out repeated data in huge spreadsheet
 

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

Any reason you can't select, copy and paste?

cklevine wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

I am a very inexperienced user, do not know much about formulas, except to
add them up-
It is a simple spreed sheet downloaded the transactions from the bank , from
a bank account with deposits and withdrawals I just need the deposits
separated so i can add them up


"Jim Thomlinson" wrote:

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--



Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

In XL hit the F1 key and type SumIf into the question box. It will give you a
description of the function.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

I am a very inexperienced user, do not know much about formulas, except to
add them up-
It is a simple spreed sheet downloaded the transactions from the bank , from
a bank account with deposits and withdrawals I just need the deposits
separated so i can add them up


"Jim Thomlinson" wrote:

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--



Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

Drar Jim,

Can one select the range of cells - I understand the formula, just not sure
if I put the range in manually or select it with the mouse-
thank
cklevine


"Jim Thomlinson" wrote:

In XL hit the F1 key and type SumIf into the question box. It will give you a
description of the function.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

I am a very inexperienced user, do not know much about formulas, except to
add them up-
It is a simple spreed sheet downloaded the transactions from the bank , from
a bank account with deposits and withdrawals I just need the deposits
separated so i can add them up


"Jim Thomlinson" wrote:

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--



Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

Help ! here is the SUM IF and I'm getting 0
=SUMIF(A2:F258,Ebay Payment Received,F2:F258)
F column is the coll which has the final numbers (deposit amounts) that I
need added up -what am I doing wrong?
thanks
Cklevine


"Jim Thomlinson" wrote:

In XL hit the F1 key and type SumIf into the question box. It will give you a
description of the function.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

I am a very inexperienced user, do not know much about formulas, except to
add them up-
It is a simple spreed sheet downloaded the transactions from the bank , from
a bank account with deposits and withdrawals I just need the deposits
separated so i can add them up


"Jim Thomlinson" wrote:

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--



Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

The second argument needs to be a text string. Note the quotes...

=SUMIF(A2:F258,"Ebay Payment Received",F2:F258)

--
HTH...

Jim Thomlinson


"cklevine" wrote:


Help ! here is the SUM IF and I'm getting 0
=SUMIF(A2:F258,Ebay Payment Received,F2:F258)
F column is the coll which has the final numbers (deposit amounts) that I
need added up -what am I doing wrong?
thanks
Cklevine


"Jim Thomlinson" wrote:

In XL hit the F1 key and type SumIf into the question box. It will give you a
description of the function.
--
HTH...

Jim Thomlinson


"cklevine" wrote:

I am a very inexperienced user, do not know much about formulas, except to
add them up-
It is a simple spreed sheet downloaded the transactions from the bank , from
a bank account with deposits and withdrawals I just need the deposits
separated so i can add them up


"Jim Thomlinson" wrote:

Why bother pulling the transactions out? You could use a SumIf or a
SumProduct formula or perhaps a pivot table to aggregate based on your
criterial... Post a few more details and we can help you with that if you
wish.
--



Jim Thomlinson


"cklevine" wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

Hi, it is running, and is giving me 0 for an answer! Should I call Microsoft
at this point? thank you so much for your help, I am just a dolt
ck

"Jim Thomlinson" wrote:

The second argument needs to be a text string. Note the quotes...

=SUMIF(A2:F258,"Ebay Payment Received",F2:F258)

--
HTH...

Jim Thomlinson

Pulling out repeated data in huge spreadsheet
 

There are over two K of these entries- I'd be doing until Christmas
CK
"Bob I" wrote:

Any reason you can't select, copy and paste?

cklevine wrote:

Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine

Pulling out repeated data in huge spreadsheet
 

If the desired information for each entry is all on a single row, simply
select the entire sheet, do Data, Sort. That way you can put the rows in
one contiguous section, then Select Copy Paste.

cklevine wrote:

There are over two K of these entries- I'd be doing until Christmas
CK
"Bob I" wrote:


Any reason you can't select, copy and paste?

cklevine wrote:


Hi, I have a huge spread sheet with the deposits and I need to pull them out
and copy them into another sheet to add them up. the text "payment received"
then the amount, is there anyway I select all of these entries (a years
worth) and copy them into another worksheet? I'm using Office 2003-
thanks a lot
cklevine