I am trying to find a formula that will count 2 columns and return one value. For example : I want to count all cells in column B that contain RI + cells in...

I'm pretty new to Excel, but I thought (and it's beeen my experience) that it ignored blank cells when doing a simple SUM. I inherited a spreadsheet that sums...

I was hoping someone could help me. I have 7 pages on a spreadsheet the first is the main and pages 2-7 are each sections from the main. I need to know if...

1. Select a cell in the table, and choose DataFilterAutoFilter 2. From the dropdown in cell F1, choose Legal 3. From the dropdown in cell Q1, choose...

HI: I'm looking for a way to use the countif function to look at 2 criteria before counting only the data that matches both. For example, say I have a table...

I'm running a standard vlookup, with the intention being that the user will enter a potential new account name into a field, and the lookup will identify...

How do I get the highest number from a column?

Assuming your price is in A1 and the prices you wish to compare are in row 3: 1. Select row 3. 2. Format Conditional Formatting 3. Select "Formula Is" in...

Hi, I have a three command buttons, one links to a particular cell on a worksheet and the other two open up a browser window. The VB for these buttons...

OK here is what I'm trying to do. I want to have an entry line where I could put things like Date/Name/Description, then hit a button and have that...

I have a schedule with 10 digit numbers in each cell (about 2,000 rows). I need to apply a different formula to each digit in the cell. Is there a way to get...

hi there... in one column i have a "date added" field - it is is month/year format in a second column (entitled "date eligible for removal) - i want to have...

I'm going crazy. I'm trying to add up a column of time. Employee enters time in and out for a two week period. The total number of hours appear in column I...

What I want is have a today function eg in cell A1. based upon entering any text in for eg b2, puts me the julian dat in cell A2, So far, so good, I got that...

One of the formulas in excel help =COUNT(A2:A8,2) that is to count the number of cells that contain numbers in the list A2:A8, and the value 2 dosen't work. ...

Due to the way someone 3 stops down the chain from me is exporting, the autocalculate function does not work with my data. For some reason, if I go in and...

I hope someone can help. I set up a spreadsheet. Each column has a different basic formula. eg column A and 1st line has an amount the column B has a...

i'm having a problem with vlookup not accepting a "reference" to a cell as the "lookup_value" this =VLOOKUP(C2,range,2) returns #N/A but if i manually type...

If I understand your question you can go to Data / Text To Columns in Excel and it will do it for you. It offers you different choices on which delimeter to...

I hope someone can help. I set up a spreadsheet. Each column has a different basic formula. eg column A and 1st line has an amount the column B has a...