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?? |
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?? |
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?? |
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?? |
=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?? |
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?? |
All times are GMT +1. The time now is 03:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com