New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

alphanumeric sum

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

alphanumeric sum

Postby bicas » Sun Dec 11, 2011 12:54 pm

hi.
i have a sheet that as alphanumeric data.
and i need a formula to sum this.
however, there are same cell that have no data and some that in front have the word debit and credit, that i need to difference in the sum.
can you help me.
thank you
in here the link to the data sheet on google.

https://docs.google.com/spreadsheet/ccc?key=0AnLGLqrITr4GdDNOX2NwVU52VmJUcHFuY2RWSmtRaGc"


thank you
  • 0

bicas
Rookie
 
Posts: 1
Joined: Dec 11, 2011
Reputation: 0

Re: alphanumeric sum

Postby Don » Sun Dec 11, 2011 2:43 pm

Hi and welcome to the forum!

What exactly do you want summed, the transaction amount column? If so, just us a basic sum function; but, I'm unable to edit anything in the document so I can't test any formulas, can you include this in an Excel spreadsheet and attach it here? Also, I don't see any cells with numbers that also contain the word "debit" or "credit."
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 32 guests

cron