I am trying to add 3 amounts. Right now the formula =SUM(D11:D12) works, but when I try to add cell D13 to that it returns a 0. D11 $8,000,000 number ...

I have a main document made and need some cells to transfer to other workbooks if certain criteria is met. Is this possible? i.e., If Cell A4 = January, &...

how do i write a function that basically says "if there's anything in cell xx, return the data from that cell. if there is nothing in cell xx, leave the cell...

I am using the following formula and have tried numerous variations with no...

I wonder if somebody can help me with this matter. I have the following formula =IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"", ("( "&C22&" ) "&D22&" (...

I would like to copy a formula into a number of cells that are 9 rows apart from each other and there are other formula on the rows between. I can filter on...

if a1 is a base number of 100 and b1 is 95 how do i get c1 to be greater or lesser than b1.

Hello. I am trying to add in the descriptive analsis toolpak to no avail! It wasn't in the add-ns box, and when I browsed the add-ins folder, it was empty....

I have used the XIRR function which returns an Effective Annual Rate of...

Hello, I have a spreadsheet that shows all games for baseball season tickets. The owner of the tickets is splitting them with two other people. He would like...

I have a worksheet where I dump exported data from another program. The worksheet has a main category in column A and subcategories in column B. (Example...

Hi Everyone, I have a problem in Microsoft Excel and I hope someone will find a solution for me. In cell A1 I have =Today() in cell B1 I have a code that...

How to tell the time? I have an Excel 2007 workbook that I require to be able to ‘countdown’ the time remaining until the scheduled start time of a...

I am trying to find out how to protect cells or columns in a sheet, without protecting the whole sheet. Is that possible or can you only protect the whole...

Hi, I am setting up a excel template and am using the worksheet protection function. I have specified "unlocked" cells. Is there a way to allow users to...

How can I count a range of dates in one column and that range has to include specific text in another column?...

I have the following source data: A1 = name (text) B1 = start date (as a number displayed in Date format) E1 = project title (a text string) F1 = hours...

how do i print a sheet in excell workbook

I have a list of dates extending out for the next 8 years and I need to put them in the quarter/year category - i.e., 3Q09 for a date that is 10/12/09. Is...