Can someone tell me why this gives me the "Sum" and not the "Avg" =AVERAGE(Sheet1!A19+Sheet2!A19) Thanks -- NotGood@All

2 worksheets Sheet 1 Area Sector Year Berkley Retail (BLANK) Berkley Office (BLANK) Clawson ...

Hello, I have a zip code as 06110 formatted as zip code. I used LEN on that zip code and it returns a 4 because it's not reading the leading zero. Is there...

This is probably easy, but I'm having a heck of a time figuring out the formula. I have two spreadsheets with similar data. I am trying to figure out if the...

I would Excel like to insert information into another work sheet in the same work book only when dates are added. Example: when filling out my finances in...

Hi, I have a spreadsheet for a count of days that a job is in each stage of progress that is sorted by unit type for 2006-2008 and for each unit type I need...

I have an array formula that sums cells in column C if their corresponding label in column B matches a desired string in cell...

I would like to know the formula to convert a date, such as *Wednesday, 1-Oct-08 to read "Wednesday", that is, plain old text which says "Wednesday". Please...

I have a spreadsheet in which I need to be able to see if one cell is larger by increments of 0.05 than add 1% per increment. Is there a formula that would...

I am working with a large list of addresses that are all in one column. i.e. / 123 Fair Ave Atlanta GA 12345 / all in a single cell. I need to break these...

Using Excel 2007; The following formula sums every other column in a range. =SUMPRODUCT((MOD(COLUMN(A1:J1),2)=0*A1:J1) How can I modify the formula to refer to...

Hello, I am using the Column function to get the Column number from a different seperate workbook like the following: =COLUMN('L:\My...

I need to copy items dow as many as 100,000 rowes is there an easy way like a/c

I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the...

I'm updateing data validation list and I useing this VBA code and that updates my list. The problem I'm haveing is I want the data to go to the end of the...

I have a date cell that I want to incorporate into a paragraph of text. I would usually use the TEXT(A1,"mmmm dd, yyyy") function but I need this date to...

I have two ODBC queries reporting back to the same worksheet. In column A, I have "work Order #", it is formatted as "number", sorted ascending and has 5...

Everytime I open our shared file, the columns on my tab that I had hidden have been unhidden. I have to hide them each time. Can I set them not to change/

I have this ABS ABS_Canada DCG_Netherland HNK_France HGP_Ontario KLG_France JKL_Canada

I was recently asked a question by my customer to explain what was meant by the way a function was written. I could not answer as I have not seen a...