I've tried a bunch of ideas but no luck yet. I used to use COUNTA() to find the number of cells in a column so I could create an array reference to the range...

i am not sure of the best way to create an Income & Expenditure Sheet for a weekly record of transactions in my small business.

I have an expense worksheet with filters, at the bottom of the sheet I have a formula calculating the total expenses. When I filter it by categories, ie:...

Does anyone know of a formula to add cells with training times in a hour+minute format? Example: Cell C1 is 1+12 (1 hour and 12 minutes traning) and cell C2...

Hello. I am creating an Expense Report worksheet and have created a simple formula that will calculate mileage based on total miles. Below is my worksheet...

How could I check if a Time value falls between two other time values? I want to essentially establish if a premises is open or not at various times of the...

I have a column with long formulas such as below. Is there a way to avoid the div/o error when dividing by zero?...

I, too, am setting up a timesheet. It is a very simple timesheet but I can't seem to figure out this (what should be) simple function. My question is: Time...

I have a worksheet with this formula =I34*H34 in J34. When cells I34 and H34 have no numbers in them J34 displays #N/A. Can you tell me how to change my...

I seem to be missing something regarding named ranges. I have entered data in column A, inserted a name that refers to:...

I am working excel 2007 and I have a workbook which consists of 33 sheets.The names of the first and last sheets are SAMPLE and SUMMARY respectively and in...

greetings everybody, am hoping to confirm something. i was using VLOOKUP, to determine a range name for the range to search, inside a VLOOKUP. kept getting...

I am copying from one sheet and pasting special (format and value) to another sheet. When I do, the date changes. I've converted the date to a general number...

Hi. My data table looks like this - located in D1:E8 Stock Condition IBM TRUE IBM TRUE IBM FALSE IBM TRUE IBM FALSE

I have a worksheet that has multiple rows that have the same name. For example. I have a worksheet that looks like this Name 401k FICA Julie ...

Hi I am populating a sales template in one Excel workbook but I want business unit managers to have access to view their respective worksheet only … I want...

I'm having problems getting the following to...

I was hoping to have a formula similar to the one I have posted. This way it can go into the main folder, look through all other folders, find all report...

How do I sum a cloumn of numbers when my reference column is blank?

Can someone point me in the right direction? I have an excel formatting problem. The contents of the cells involved are calculated as follows: cellA...