#formula

Hi everyone, I hope you can see the image I've attached I've got a .csv file which has temperature readings every minute so each cell is 1 minute Basically I want to count the number of cells between 85 and 95 but only when a 3rd column is equal to 93 The 93 is the oven setpoint so I need to...

I have two databases from two different sources, I created a pivot table to summarize the data. Then, I copied and pasted values to a new worksheet for sales by cost centers. First, I noticed that there was missing cost centers from one of the databases. I need to compare these two lists to...

Hi All I am using Excel 2007 and wanting to create a formula that will stop at the lowest row with a value. The first row would be 3 and the final row 22. The basic formula would be =sum(c$3:c?)/sum(b$3:b?) I am sure it would be an IF formula but not sure what the conditions would be...

An employee is eligible for retirement if he or she satisfies at least one of the following three criteria: (i) the employee has worked here for at least 40 years (ii)the employee is 65 or over (iii)the employee has worked here for at least 30 years and is 60 or over (a) Create a worksheet...