I want to sum a column and exclude those ending with cr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sum a column.. series goes like this... $306, $200CR, $500...
I want to add the cells that do not end with CR.. how??
 
Depends on the type of data you're working with.

Click in the $306 cell and post back with what you see in the formula bar.

Same thing for the $200CR cell.
 
Its a worksheet, Just want it to add the ones not ending with cr.. Instead
its adding them all.. In theory i need it to add the ones not ending with cr
and then subtract those ending with cr from the total of those ending without
cr..

Column G Cells 11-32
$642CR
$306CR
$143CR
$207CR
$350CR
$327
$297
$441
 
Not being an overly bright fellow, I can't understand your data type.
So ... once again I ask, could you click in the cell that displays
$642CR
And post back with what you see in the formula bar.

OR, you could post back with the formula that you're currently using that
you say is adding all the values.
 
=SUM(G11:G35)

RagDyer said:
Not being an overly bright fellow, I can't understand your data type.
So ... once again I ask, could you click in the cell that displays
$642CR
And post back with what you see in the formula bar.

OR, you could post back with the formula that you're currently using that
you say is adding all the values.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows problem 7
HELP! Need to sum columns where credit balances are shown as ###CR 20
Sum Values from different column 1
Dsum Help 0
total a column in which there are sum formula 4
Change positive number to negative number 1
Extraction 12
How do I exclude a cell from a range? 4

Back
Top