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