Hi The spreadsheet shows people on up to 20 differant projects with each project have 2 colums of data i.e. BY and BZ. My example cuts it down to 4 columns...

I am trying to count two columns IF a 3rd colum equals a certain text. This function will count the two columns just...

Hello guys this is my first post. I am having a issues with tracking information from multiple worksheets in the same document I have listed the names of...

EUR GBP USD Jan-09 1.1205 1.0000 1.4500 Feb-09 1.1261 1.0000 1.4573 Mar-09 1.1317 1.0000 1.4645 Apr-09 1.1374 1.0000 1.4719...

Hi, I have a list of companies, need to look at a separate list of countries and, if any of the companies are in countries found in that list, I want to...

I am creating a holiday card for staff in the office and wanted to know if there is a sumif function for adding up the number of times a specific letter...

Hello-- I have a formula entered as follows: '=VLOOKUP(A8,Sheet1!$B$22:$O$22,2,FALSE) My Sheet 1 - match column is this: Row Column B 22 ...

How do I get Excel 2003 to do this? I want to be able to add increase and decrease arrow icons to a column of numbers . Thx

Got a big long column D containing times formatted as i.e. 13:30. I am trying to do a countif function for finding the count of inputs between 6 am and...

I would like to use a SUMIF formula to add multiple columns. For instance, I have a list of materials in a range from A6:A2403 and sales dollars for each...

Does anyone know how to get Excel to recognize a word as a numeric value? I have gone into InsertNameDefine and assigned a numeric value to the word. Lets...

Through great effort, I have sorted and averaged the patient demand for appointments over the last three years. For instance, now I know how many patients...

hi, have a series of dates but everytime i try converting them to text a number comes up. How can I convert my dates to text but keep the date format. Please...

Good day all, I am trying to change this number 01-465-9273 to show up as 014659273. It is easy enough to make the (-) go away but it takes the zeros at the...

Hello All, I'm having a hard time creating a formula to collect data for work. Here is what I'm looking to do: To explain I will use cells A1, A2, A3 & A4....

I have the formula bellow, which is getting a number from a worksheet within the permanent file to be added to the monthly...

Hi, I'm using xl 2007. I need to sum figures in column B if the relevant cell in column F has an entry that starts SM. I was trying to use SUMPRODUCT but I...

I am setting up a list for cells. I am using data validation and picking a named range. I have no issue if the range is in the active workbook. but i need to...

I need to be able to pull counts from a frequently updated list based on associate's name and status of order. -- Amethyst