I have a cell where I need to keep the amounts separate to show workings out, but I need this to be then added up in a sum, is there a way to do this as at...

Hi! How do I add the sum of E21 across all but one worksheet? The worksheet name has been changed to the first day of the week--053005, etc. E21 contains the...

Hello, How do I write a function that adds the values for the intersection between row 12 and every 7th column (to give a concrete example) . To...

I will try to explain this the best that I can... I have around 100 excel workbooks that contain the same exact sheets in each. In each of these worksheets...

Hi, I am trying to add cells from a column based on two conditions. For example: the chart below is on one worksheet and on another I am consolidating...

I have in cell F26 numbers from 0-24, I need to ad together cells K52 and J52 only if cell F26 does not contains number 1, if cell F26 contains number 1, I do...

I have a sheet where i have applied a filter so i can see only one group of numbers, i want to do a sum on these number but ignore the hidden cells. is there...

Hi, Using Excel 2003 sp3 and all available addons I am trying to add a row of cells up to the current week. I have the Week Ending in a row number 2 and the...

I have a excell file that has several worksheets and on each worksheet it has several employees names and %'s. Is there some way I can have a worksheet at...

I have a workbook that has a sheet for each month with vendor data. I'd like to add all the cells for each particular vendor on an overview sheet. Any ideas?

Hello, Thank you for helping, as I am not too familiar with the advanced funtions of Excel. I am working with a very large worksheet and would like to add...

How do I add cells together from different sheets within a workbook

I have a column of data with several hundred rows. I want to add every other row and show the results in another cell. How would i go about doing this? How...

On sheet 1 Column1 is a date function that returns the number of months sales have come in, it is formatted as a number. On the same sheet in Column 2 I...

I am invariably typing text into Excel for Mail Merge Lists and would love to just type straight and convert the text using a Change Case Funtion such as you...

hi all, is there a formula to add characters to all fields in a column? like add Croco at the beginning of each cell all along the column... Thank you in...

How can you use colors as a result in a formula, i.e. color a cell red when 30 days from due date, color green when task accomplished.

hello i'm trying to have the cell color change when the value is false when using the IF function

How do you add, for example: item 2 from column A to item 2 from column B to yield item 2 from column C. Then item 3 from column A to item 3 from column B to...

I have 2 columns, one showing Sales (Col B) and one showing Hours (Col A) - This shows the Sales per Hour How can I add up the Total Sales for a given Start...