Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to sum a column and exclude those ending with cr
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?? |
#2
|
|||
|
|||
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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cbanks" wrote in message ... 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?? |
#3
|
|||
|
|||
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 "RagDyer" wrote: 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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cbanks" wrote in message ... 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?? |
#4
|
|||
|
|||
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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cbanks" wrote in message ... 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 "RagDyer" wrote: 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. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "cbanks" wrote in message ... 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?? |
#5
|
|||
|
|||
=SUM(G11:G35)
"RagDyer" wrote: 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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cbanks" wrote in message ... 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 "RagDyer" wrote: 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. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "cbanks" wrote in message ... 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?? |
#6
|
|||
|
|||
Hi
Try =SUMIF(G11:G35,"0") Regards Roger Govier cbanks wrote: =SUM(G11:G35) "RagDyer" wrote: 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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cbanks" wrote in message ... 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 "RagDyer" wrote: 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. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "cbanks" wrote in message ... 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a formula that sums a column but could exclude some cells | Excel Worksheet Functions | |||
How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions | |||
Average/Min column of numbers, but skip 0's and Null's in the form | Excel Worksheet Functions |