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?
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.
