I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64"". So again, I would like it to check for the cells in Column B that = "AA" and of...

I am using this macro. Sub Hill() Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection,...

I have a spreadsheet that has total hours for Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec. (B21:M21) In these fields are values up until the...

The sum range in my formula includes 3 columns. My formula is working but only picking up numbers from the first column. What am I doing wrong? --...

Does someone know how to increase the levels of nesting that will be allowed in excel? Currently it's 8 levels.

I am building a testing log. Col A contains the test number (values 1-4). Col D contains the test result codes (values 1-11). I can count how many results...

okay, so i have a single line of imported addresses where the entire address is in one cell. I don't want to move cities, etc. to another cell; I just want...

I have a spreadsheet with sub-totals which calculate the columns at the bottom - like below. April 1.00 May 2.00 August ...

I am trying to multiply 2 cells in a separate cell then multiply the total by a percentage and add the percentage to get the final total in a single cell....

Basically i have set of numbers that are numerical, 1 to what ever is generated for that column (a19 is where they start), i need to take the number from...

Hi I would like to set up my spread sheet so that when I scroll down the headers of the various columns scroll with it so that I always have the headers of...

I have a worksheet where cells J5, M5, P5 All the way through AW5 have dates formatted in the mm/dd/yyyy format. Ideally I want to enter in the date in the...

Please give formula for age from Date of Birth i.e. what is the age of: 14-Dec-54 12-Σεπ-57

Im using the if and then formula, which the =now() formula is included within. Once I save, I want the date and time to remain the same and not change to...

I am making a spreedsheet dealing with resumes, I made a drop down list, is there a way that I can select more then one topic from the drop down list?

I've got a spreadsheet that includes 3 columns with range names of 'gender' (containing either M or F), 'age' and 'company_service' (both expressed as...

Cell A1 is for school name. Used Data Validation to provide a drop down list to choose school name. Cell A2 is for school address. Would like a school's...

hello all, I am looking to copy a macro from one workbook on my hard drive to another workbook that is located on a server. is there an easy way to...

I would like to create a "countdown clock" that reflects the number of hours/minutes/seconds remaining for an employee to work based upon their scheduled...

How do you change this feature? When I scroll it shows the cell numbers. I'd like to see the data scrolling instead. We have several computers here and both...