what allows me to select cells for use in a formula by using a mouseee.

I have been trying to use SUMPRODUCT to count the number of data entries that are less than 23 (column F) by quarter (date is in column C). I can't seem to...

I need the formula to calculate dates (Mondy to Friday) without counting the weekends

I am trying to create a function in a checkbook register type workbook that will do the following: if name in column a = x and date in column c = y then add...

Excel 2000 ... I have a date (01/01/05) in cell V1. In 12 other cells I would like to put formula that will give me months of year January, February, March...

I have a worksheet that has vlookup formulas that refer to another file. If this file is a semicolon delimited file, do I have to have it open for my master...

I would like a column to be hidden as long as all the values in the cells are 0. When a formula in one the cells in this column is returning a positive value...

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

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

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

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

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

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

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

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

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

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

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