LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Calculating a sum, exceptions for specific values

Utter newbie here so please forgive stupid questions.

I have a column with values that I would like to sum up, so far no
problem.

However, if someone enters a specific number, this cell is to be
ignored and excluded from the total sum.

Can this be done somehow?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? yadang Excel Discussion (Misc queries) 2 October 1st 09 06:18 PM
calculating sum and average values for specific days only Soccerboy83 Excel Discussion (Misc queries) 2 September 2nd 09 10:38 PM
Calculating Months within a specific period Sarah Excel Discussion (Misc queries) 6 October 18th 08 11:02 PM
Calculating for a specific date range Christy P Excel Worksheet Functions 3 April 20th 07 05:55 PM
CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES PaulH-Oz Excel Worksheet Functions 0 March 26th 06 11:50 PM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"