I am trying to get min & average 0n cells...

I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell....

using formula in A2 =average(IT:Index(A1:IT1,sumproduct(large(column(A:IT)* (A1:IT1""),A4)))) A4 is variable cell for calculation. However, I require result...

I have formatted 2 cells say A1 and B1 as time and chose the first type being in the form 13:30 - This shows up in the equation line as 1:12:00 PM. So I type...

I print karaoke books with the artist in column 1 and the song titles in column2.. Is there a way to move each artists song titles below the artists name...

I keep track of real driver statistics (Nascar) and am involved in an online racing league and keep track of those stats as well. I've made a workbook...

Hi Trying to add 4 days to date in cell A1, without counting weekend and if poss bank holidays. in cell C1 example cell a1 = date cell b1 = time If time...

Firstly I'm a total newb to excel (and access for that matter LOL) I have almost 25,000 rows of data and I'm a little scared LOL its a basic set up, Total,...

Hello everyone, Can anybody offer a solution to my problem: I have a list of 4 digit numbers in column A (I need to retain leading zeros for numbers ...

When I protect a sheet, and the only action allowed is "Select unlocked cells", the user cannot select any locked cells, which is what I want. When I save the...

I have a question about how to write a formula to include specific info in a range of cells. I have a range of cells I want to include in a formula but I want...

I'm new here so I'm not sure if this is exactly where it's supposed to go because I didn't want to post it anywhere else in case it was to simple of a...

Using Excel 97 on WINNT Each fortnight I receive a report which is then formatted and saved using a dated filename for the next Wednesday e.g. "570...

Can I make it any simplier. I want to make a tracking form. The first col. A is customer name and address,Col. B is date of purchase, Col. C is method of...

Hi I would like to colour a cell based on 4 different criteria. eg: if cell A1=1 then red, A1=2 then green, A1=3 then blue, A1=4 then purple and of A1 is...

How to format a column as three-letter week, eg. Tuesday-TUE thanks

Here's my formula: =YEARFRAC(B3,$D$2) I get an error (#NAME$) What am I doing wrong? Thanks, Doug

i need to download excel on to my pc from the web, can anyone explain how i do this, please

Hi. I am using MS Excel 2003, and I am very new to the program, so if you can help me, please explain everything in very easy English. I need to fill many...

I want to create a formula to allow me to enter a # into a cell that will display a corresponding months name in that cell. In doing an IF statement I have...