formula calculation

Hi guys Im new to forum and need some help..sorry to be demanding after just joining:( if someone can help explain me to do this would be great I wish to make a spreasheet to help me make picks in 2 team sports,il try show example below. Its based on the amount of goals a team scores in...

I am new to access 2003 and I've been trying to add a formula to an existing access form. The Formula I need solved is (((L x R)(/A))(/12))=F L - Labels R - Repeat A - Across F - Footage I want to be able to enter the various numbers and have it solve what's missing. I always have the...

:eeek: Ok here goes.... i have an extensive sheet with about 220 pages in it (page breaks ) here is the thing, when i add a new page into it i have to manually go re-number all the following pages. ( big shlep !) a.s.a.p utilities has a info tool that will tell you on wich page number your...

I have conditional statement {=SUM(IF('name of sheet'!$H$2:$H$226=H8,1,0))} When ever I try to add a 2nd condition in using the wizard, I get incorrect results. H8 is the cell that I want the calculation based on. How do I put on there that I want the calculation based on H8 or H9. If the...

Hello, I am hoping somebody can point me in the right direction... In Excel 2007, I am pasting (using Paste Special, Values to maintain formatting) data into an existing spreadsheet in columns A-J, with formulas in columns K-M, which is all a named range "SWData". The data I'm pasting in is...

Hello, Excel Friends. My obstacle may not have a fix, but I must ask. I have a column that has file nos. for matters (e.g., 0B-040300US). The seventh character of the file no. identifies the family it belongs to. For instance, all the following matters (0B-040300US, 0B-040301US, and...

I supervise a union workforce. When filling open jobs there are rules we must follow. One of these rules are that the most senior personnel must be offered the overtime 1st as long as they have 8 hours off before and after the open shift. The pasted example of one of the 50 job discriptions...

I created a worksheet with the following code to cause a macro to execute when the values in certain cells change: Private Sub Worksheet_Change(ByVal Target As Range) 'Check to see that we have enabled auto macro updating If Range("Report_Type_Auto_Run_Macros") = "ENABLED" Then...

The formula in cells R7 and S7 don't calculate. When I fill in the numbers in cell J7 and K7 manually it works, but when I use a link to cell T3 and T4 it won't work. Hope someone can help me out. I have checked the format of the sheet. Doesn't work when all the cells have the same format...

Having a little problem. A formula doesn't calculate. When I put the number in manually it works, but when I use a link to a cell with the number it won't work. Hope someone can help me out. I have checked the format of the sheet. Doesn't work when all the cells have the same format... Bit...