How can I enter a non-adjacent range into the countif function? When I hold the Control key and select the cells of a non-adjacent range commas are put...

Hi, I can't seem to get the TRANSPOSE formula to work. As I understand the TRANSPOSE formula transposes an array, say a column of numbers into a row. However...

I have two columns with different values and I want to count as follows: (If column A has the value "writing" or if column A has the value of "to do") AND (if...

When I put two different dates in two different cells, then subtract the two dates with a formula in a third cell, I get a whole number of days between the...

Can I retrieve a worksheet that changes where made to after I saved it? I thought I was copying a sheet, but I just moved it and made changes.

I am trying to do a vlookup using IF. I have 3 values to stipulate. If it is blank -return a blank cell, if it is zero -return the word "add", and if any other...

Hi - I receive spreadsheet reports weekly that have several thousand records. I subtotal these reports to derive subtotals for specific customers. I...

I think I have found a bug in the "minute()" function. If you perform the function on a time that has seconds greater than 59.50 it returns a minute value that...

Hi, I'm not a function person, usually VB, so I'm not sure how to do this or know if this is possible. I'll see if I can explain my problem. I'm trying to...

Is it possible to create a formula that would read a numeric number from a cell and would then write it out in alpha characters in a different...

I would like to know how to have excel keep a running balance for my cheque book record. I would have the usual col for date, cheque no etc and then three for...

Hello, I know this sounds like a simple problem but I am having the hardest time editing a comment, we are in a shared workbook and when I try to edit a...

I'm not very good with formulas and I can't seem to figure out how to get the age of someone when I have their birthdate. Does anyone know how to do this?

Hi I am sitting with a spread that i need to count the number of people that are between the ages of 29 and 40. i tried using the countif, but i seem to have...

I have a simple "sum" forumla or just reference a cell used in different worksheets in the same workbook. If I cut data and move the columns over, i get a...

I have a few spreadsheets that have about 30 tabs at the bottom. I am trying to copy a formula that is counting a running total of a cell in all sheets. Each...

I have a spreadsheet that has due dates on it. I would like to have it total the $ information sorted within a calendar work week. i.e. all items ordered...

I have a worksheet with 312 rows and I want to add 4 blank rows below each existing row to imput some additional datta. Can you tell me how to do...

1. I am trying to change the color of a date to red whenever the date in a cell is greater than or equal to 90 days olds when compare to todays date. 2. ...

I am interested in adding the values of cells, based on how the number appears. In my case, the numbers have been rounded either up or down, and appear...