I know this can be done, I just can remember how or seem to be able to find it under help. I would like the border around my active cell to be a different...

Hi, SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44 Looking to modify...

I have colum A and B. I use SUMPRODUCT to calculate the sum of values in column B with a criteria. What I would like to do is copy the cells from column A...

How a password is set in excel sheet. When double click an excel file, first of all you see protected and a window appeared, asking for password to open...

Hello, I made conditional formulas but with the numbers that result I am unable to calculate their average. I get the #DIV/0! error. They are formatted as...

I was trying to format time in decimals to days:hours:mins format. While using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But...

Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...

I have a spreadsheet with $costs arranged according to values in both rows and columns. How do I create drop down lists for both the rows and columns and then...

I imported a spreadsheet. One column contains multiple data lines that I want to put into separate columns. They are consistent in their presentation. How...

I am using this formula to enter text into a column of cells of the source worksheet and the corresponding column of cells in the destination worksheet;...

Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not...

I am interested in linking a formula to the colour of the cell. Ie. positive number would produce a green cell & negative cell would high light the cell in...

I'm using Excel 2003 so I hope I'm not limited here. We are performing a space usage survey and I need to compile the data results. Each location has 70...

Hi, I need some assistance with tracking my commissions that are due to be paid each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by...

I have the various dates on which our staff have joined the organisation. I need a column that would convert all the year part of the date into the current...

I need help with correct formula to take a starting date from one cell and place a formula in another cell that will increase the number by one for every 365...

I have one summary worksheet and approximately 45 data worksheets. Each row on the summary page needs 8 - 10 cells from each data worksheet. The...

hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...

I have a large spreadhsheet with data I've manually copied/pasted from various sources including web pages. As I am trying to do things like import to Mysql...

We will be hosting a large fund raiser. I need to know the number of people attending. Here's my problem................ Some people come as couples, and...