I am wondering how to add to a previously summed number. For example, I had + .4420+.0080+.0020-.0025 + .0075 - .0040 in a cell with a closing value of...

sorry ignore first part, see tables. Change example, forgot to delete acopper57 wrote: I am wondering how to add to a previously summed number. For...

Sorry, when I posted it, it made it look a bit different. It should be the answer is four because there are four occurances of one in column b. --- Message...

I would like to know how to create a formula to count the number of occurances of a specific item in a column. I want to count the occurances of 1 from cell...

Not sure if this is even possible but here's the scenario. Want to change date on worksheet 1, have the lookup function find the date match on worksheet 2...

I need the following number to look as follows: Is: $ 1,075,245 Want: $ 1,075.2 Not all of the numbers are millions so I want the $ to line up to the...

I have a group of numbers, some of which add up to a given sum. How can I find out which numbers make up that sum?

How do I reformat a group of numbers like 203.00 to 203-00? thanks

I want to create a user-friendly grade sheet for an exercise within a course. Each of 4 days of student work is considered separately for this score and all...

Has anyone else had problems losing changes on a shared workbook? I have an Excel 2003 workbook shared between multiple people and saved on a network. We have...

I have created a new workbook then started uploading data. The data then got divided into 1,233 seperate sheets. I would like to combine all the data on to...

I would like to do calculations in my spread sheet with 30 digits precision. I figure this is possible because the number display allows 30 digits. I went...

I have a file that I have to fill out for one of our buyers and it has two sheets to it. Some of the information that I enter on one worksheet can also be...

I know how to hide a sheet but i do i prevent a user from performing the unhide? Does it have to be done using VB or hiding a particular toolbar? Thanks,

This is probably the most simplest question;; I have an amount in e4 and i need that amount subtracted by 50 percent for the results to be in f4.Can someone...

New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure...

I am working on various cells that are repetitive. I have two countries which have a total amount but need a percentage subtracted. brazil total...

I have columns that list invoices ,invoice dates, accounts ,subtotals and totals. When i try to drag the data item into the DROP DATA ITEMS HERE , it...

I have column E and F which contains dollar amounts and users need to enter same dollar amounts in both columns. For example column E is 100 and column F...

I have 2 excel files. I would like to link multiple cell in file 1 to file 2 I am trying to get around from going to each cell & going back & forth from file...