Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Monday 18.8.2025 / 18:20
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - general discussion > ms excel help/question
Show topics
 
Forums
Forums
MS Excel help/question
  Jump to:
 
Posted Message
eoquest69
Newbie
_ 		30. July 2007 @ 01:53 _ Link to this message    Send private message to this user   
I have a spreadsheet with 5 columns. Column two is formatted to add and column four just has a checkmark. my question is, can i somehow link the info from column two cells into the cells from column four, but without changing the checkmark and at the of column four, show a total.

Ex:

Column 1 Column 2 Column 3 Column 4 Column 5

Name Here 4 Address Here √ Phone #
Name Here 1 Address Here Phone #


At the end of column two, i have a total of this column since all occupied cells have a number. however, in column four, not all cells have a checkmark. on the same row that has the total for column two, i want to put a total for column four, but it should somehow add the numbers in column two that have a checkmark. So, like in the example, column two, row one, has 4 and is checkmarked. Column two, row two is not checkmarked. At the end of column two, the total is 5. For column four at end, the total is to be 4. How can i do that without changing the formatting of column four, except for the cell that is to contain the total?
[ + quote]
Ripper
AfterDawn Addict
_ 		30. July 2007 @ 03:59 _ Link to this message    Send private message to this user   
Here's a piece of advice - go to this website...

http://zshare.net

..and upload your spreadsheet file to it. Then, post the link back here so people can take a look at what they're dealing with, rather than a poorly formatted example in your post (through no fault of your own, the forum code changes it about after posting).

Then we can help you and edit the spreadsheet for you ourselves if need be.
[ + quote]
eoquest69
Newbie
_ 		30. July 2007 @ 15:30 _ Link to this message    Send private message to this user   
Here's the excel file: List.xls
[ + quote]
afterdawn.com > forums > software, operating systems and more > windows - general discussion > ms excel help/question
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2025 by AfterDawn Ltd.

  IDG TechNetwork