results in separate cell

Hi, I am trying to find a better way of calculating total metrics of our test results from various sets of tests. The cut down table and the text below shows how we are currently doing it, but the formula is going to be too long to do it on the next sheet so I am looking for a more simple way...

Hello and I apologise in advance if this is a stupid newbie question (but thats what i am). I have an Excel sheet i'm working on, for tracking customers. I currently enter their first and last names in separate cells and have a formula that extracts the first few letters of each, to make up the...

Hopefully someone out there can help me with this; it's been years since I touched Excel. It may be important to note that I'm doing most of the creation of this spreadsheet on Office 2010 (on my home computer) but I need to make the spreadsheet compatible with Excel 2003 (on my computer and...

I have done some of the coding already but now i am trying to do the coding for displaying results on worksheet. So there are four different column A- D and the represent a specific table in the database tables i loop through. so i want to results to be displayed in the specific column after...

How does one keep your formula in one cell, but display it in a separate one for eg. 2 cells away? Even one cell away would be fine.