I USED THE HELP AND THE EXAMPLE BUT IT DIDN'T WORK, ANY HELP??? THE EXAMPLE IS GOOD IF I WANT TO PUT ONE NUMBER BUT NOT A CELL. I'M USEING OFFICE 2003

I need one more argument in Networkdays function after Startdate and Enddate, weekend day or days in form of 1,2,3,4,5,6,7 before holdays Any solution Thanx

In cells d7:D36 I have dates. In cells e7:E37 i have corresponding point values. I can use sumproduct to provide a value for the last month from today. I'd...

In the past, I could create tables where I entered formulas in 2 cells then dragged the handle down and Excel would autofill the formula in the...

Hi, I'm trying to create a very simple time sheet by weeks, not days. column A is employees name, B is the week worked, C is total hrs. for that week, D is...

Hello to everybody, I have an invoice template almost finished and I would like to add a button that increase the numer of the invoice of 1. How may I do...

How does a complete beginner go about creating a formula? Is there a list of what each letter & symbol represents and how & where to use them? So far I have...

I have office 2003. I have a list of names and titles that is 19 pages long. 1000+ entries. I have headings on page one and have sorted it by the 3 different...

On Excel 97, when you subtotal on one column and then subtotal on a second column, it puts the first group's subtotal below all of the subtotals for the second...

It appears I can type a named range in table_array, but I cannot either 1) link to a cell containg the named range. or (#N/A) 2) use a nested Vlookup to return...

When I enter the function in a cell, the result is correct in the set up. When I hit enter, the only thing taht is up into the cell is the VLOOKUP formula and...

I'm curious to whether or not this particular action that I'm trying make happen is possible w/o the aide of macros. The problem is that I'm trying to take...

When I try to use the IF function and try to say that if a cetain cell has a value of N/A, the value of this cell should be 1, otherwise it should be...

I use a form that includes lookup tables. one of the lookup tables contains financial accounting dates, e.g.,week 1 on lu table is 01/03/05 and 01/07/05 then...

Here's the situation; I'm a high school soccer coach and want to record player game stats on one sheet for a given game & date, and have that same data appear...

Need some help guys. I have a spreadsheet with data that totals and then within the same worksheet I have a summary of the totals. Example: I have a cell with...

I am entering the following =COUNTIF(AC5:AI150,"True"). Basically, what happens now is Excel is creating a Circular referance, I had this working on another...

In other words, I have a list of dates with hours and costs from January thru December on one worksheet. I want to have another worksheet calculate...

Hi there. I have our price book set up in Excell. There are patterns and underlines that are in the Excell file that ARE NOT copying into Quark. I use...

I have an age column and a DOB column, What is the formula to calculate the age by using the date of birth.