| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling data automatically from one spreadsheet to another | Excel Worksheet Functions | |||
| Pulling data from multiple spreadsheet | Excel Worksheet Functions | |||
| Exported data pulling into another spreadsheet | Excel Discussion (Misc queries) | |||
| Please Help! - Need Help pulling data from one spreadsheet to anot | Excel Worksheet Functions | |||
| Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
