| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING NUMBERS IN A COLUMN
Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL
IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
First.........please lose the Caps Lock.......hard on the ears and difficult to
read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
What am I to replace in this formula? All the numbers are different in 408 rows
"Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
408 rows in the same column?
Or in multiple columns? Assuming one column................. =SUMIF($A$1:$A$408,"0",$A$1:$A$408) If multiple columns please post where your data is located. Gord On Thu, 11 Oct 2007 10:00:01 -0700, cb wrote: What am I to replace in this formula? All the numbers are different in 408 rows "Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
Thanks for your replies
this is the figure I received 15216607 cannot be correct- perhaps maybe 152 thousand at the most I placed the formula in the formula bar and clicked the check mark- not sure where and or if the cursor is to be somewhere? "Gord Dibben" wrote: 408 rows in the same column? Or in multiple columns? Assuming one column................. =SUMIF($A$1:$A$408,"0",$A$1:$A$408) If multiple columns please post where your data is located. Gord On Thu, 11 Oct 2007 10:00:01 -0700, cb wrote: What am I to replace in this formula? All the numbers are different in 408 rows "Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
Copy the formula to an unused cell.
Don't know what checkmark you are referring to. Gord On Thu, 11 Oct 2007 11:03:01 -0700, cb wrote: Thanks for your replies this is the figure I received 15216607 cannot be correct- perhaps maybe 152 thousand at the most I placed the formula in the formula bar and clicked the check mark- not sure where and or if the cursor is to be somewhere? "Gord Dibben" wrote: 408 rows in the same column? Or in multiple columns? Assuming one column................. =SUMIF($A$1:$A$408,"0",$A$1:$A$408) If multiple columns please post where your data is located. Gord On Thu, 11 Oct 2007 10:00:01 -0700, cb wrote: What am I to replace in this formula? All the numbers are different in 408 rows "Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
Copied formula to an open cell beneath the column I want to add- still get
the same figure- the check mark I was referring to is on the open menu bar above the actual sheet . There is a x, check mark and a fx sign to the right of that is the blank space to place the formula as I did that before and got that high number. I am assuming I just hit enter and it will formulate? "Gord Dibben" wrote: Copy the formula to an unused cell. Don't know what checkmark you are referring to. Gord On Thu, 11 Oct 2007 11:03:01 -0700, cb wrote: Thanks for your replies this is the figure I received 15216607 cannot be correct- perhaps maybe 152 thousand at the most I placed the formula in the formula bar and clicked the check mark- not sure where and or if the cursor is to be somewhere? "Gord Dibben" wrote: 408 rows in the same column? Or in multiple columns? Assuming one column................. =SUMIF($A$1:$A$408,"0",$A$1:$A$408) If multiple columns please post where your data is located. Gord On Thu, 11 Oct 2007 10:00:01 -0700, cb wrote: What am I to replace in this formula? All the numbers are different in 408 rows "Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADDING NUMBERS IN A COLUMN
Type or copy the formula to an empty cell and hit ENTER key.
Not being able to see your data, I have no idea whether your formula returns the correct results or not. Use either of the 2 free filehosts below to upload a sample of your actual worksheet. (Desensitize it first, if needed). Then copy & paste the generated link to your sample file in response he http://www.flypicture.com/ http://cjoint.com/index.php Gord On Thu, 11 Oct 2007 13:04:03 -0700, cb wrote: Copied formula to an open cell beneath the column I want to add- still get the same figure- the check mark I was referring to is on the open menu bar above the actual sheet . There is a x, check mark and a fx sign to the right of that is the blank space to place the formula as I did that before and got that high number. I am assuming I just hit enter and it will formulate? "Gord Dibben" wrote: Copy the formula to an unused cell. Don't know what checkmark you are referring to. Gord On Thu, 11 Oct 2007 11:03:01 -0700, cb wrote: Thanks for your replies this is the figure I received 15216607 cannot be correct- perhaps maybe 152 thousand at the most I placed the formula in the formula bar and clicked the check mark- not sure where and or if the cursor is to be somewhere? "Gord Dibben" wrote: 408 rows in the same column? Or in multiple columns? Assuming one column................. =SUMIF($A$1:$A$408,"0",$A$1:$A$408) If multiple columns please post where your data is located. Gord On Thu, 11 Oct 2007 10:00:01 -0700, cb wrote: What am I to replace in this formula? All the numbers are different in 408 rows "Gord Dibben" wrote: First.........please lose the Caps Lock.......hard on the ears and difficult to read. To find sum of credits =SUMIF($A$1:$A$10,"0",$A$1:$A$10) To find sum of debits =SUMIF($A$1:$A$10,"<0",$A$1:$A$10) Other than that, hard to tell what your "absolute mess" needs to get straightened out. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 16:46:01 -0700, cb wrote: Ai HAVE DOWNLOADED A REPORT FROM PAY PAL. IT DOES NOT GIVE ME TOTAL SALES ALL IN JUST ONE COLUMN. IN THE COLUMN ARE SALES AND REFUNDS, WITHDRAWALS, WEB PAYMENT ACCEPTED, ECHECK RECEIVED ETC ETC, FOR THE NEXT COLUMN WITH THE NUMBERS, IT IS APPEARING AS MINUS AND CREDITS. HOW DO I ADD ALL THE SALES AND THEN ADD ALL THE CREDITS. IN THE ROWS ARE PERSONAL NAMES, IT SAYS REFUNDS AND THE NAME, AND FOR THE SALES, IT JUST SAYS THE NAME. THEY HAVE ALSO PLACED THE WITHDRAWALS AS WELL AS RECEIVED PAYMENTS IN THE SAME COLUMNS SO IF I AM ADDING ALL THIS UP THERE MAY BE DUPLICATES. I DID AND AUTOSUM OF HIGHLIGHTING THE COLUMN AND IT DOES NOT SEEM CORRECT THEIR FILE LOOKS LIKE AN ABSOLUTE MESS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| Adding a % value to a column of numbers | Excel Worksheet Functions | |||
| Adding numbers in a column | New Users to Excel | |||
| Adding to a column of numbers | Excel Worksheet Functions | |||
| Adding more than 30 numbers in a column | Excel Worksheet Functions | |||
Linear Mode
