HOW do you calculate the totals in a range of cells with IF formula results?

Excel 2002 I have tried =IF(A110,A1+1,0) but that doesn't work now I'm lost for ideas. Any help would be appreciated Thanks in advance

I have a very large spreadsheet with columns going to DE. I would like to create a sum formula on say column DF which would take the number enetered on say...

I have three worksheets going on with dynamic content between all three worksheets (data is entered on sheet and then shows up on another sheet). I manually...

I have three worksheets going on with dynamic content between all three worksheets (data is entered on sheet and then shows up on another sheet). I manually...

How do I create a math formula that remains in excel? The formula allows simple math calculations by clicking on an empty cell, the equal sign, the...

if column_a changes the color, i want column_b change to the same color. how can i do that? thx.

I want to count the number of "x" in a given date range in sheet2. sheet1 has every date listed from Jan1 2009 thru Dec 31 2009 I want to see daily how...

I have a workbook with three spreadsheets that is getting to large to manage and I would like to automate it as much as possible. I have been tinkering with...

Hi, all I've got a filtered spreadsheet constructed of about 40 columns and less than 2000 rows of data. At times, the file runs very smoothly and delivers...

Hi, I have text data on sheet1 (UserSort) in columns A and B - random order cannot be changed column B does not have text data in every cell, some are...

Hi, I have text data on sheet1 (UserSort) in columns A and B - random order cannot be changed column B does not have text data in every cell, some are...

I'm looking for a formula that will Count the # of months of the duration of a project (row). In this example, I want a formula to calculate the # of months...

I am trying to filter a list of 5000 names of different items, where there are "like" names in different rows. I need to be able to show/delete the like...

I'm doing something wrong in combining the 2 formulas below. I posted this q before, answer was helpful but I did not give all details on how I want the...

Hi - I currently have this formula: =IF(T210,�Y�,� “) Problem is, if cell T2 is blank/null, I still get a “Y�, but I don’t want one. How...

Hi, I have this function =SUM(IF($D$25:$D$993="x",IF($B$25:$B$976=""&A3,1),0)) from excel 2003 and now have converted the spreadsheet to 2007. I have...

Hi, I have 2 columns, col_a & col_B. col_b is Date format. If I change date (Any date) for col_b, col-a is goinging to change the text from "a" to "t" How...

I created a Data Validation drop down menu. I am using symbols (specifically a check mark) from the wingdings font. The data displays the proper symbol on...

Hello. I am trying to create a spreadsheet with conditional drop down lists, and it works fine except for one column in the reference list. I have 7 columns...