# formula

(113 results)

Select:
Content Type:

### Transposing Excel data via the fixed and live methods

April 2, 2013 7:57am PDT

Transposing Excel data via the fixed and live methods article root Fixing Formulae Fixing the formulae (\$ signs before and after the Column reference in each formula) retains the linkages after...

1 Started by rki@...  |

### Determine the remaining number of days in the same year

March 24, 2013 2:19pm PDT

Determine the remaining number of days in the same year article root Follow on question Thanks, Susan, this is great info! Now, how about if I want to enter a starting date in \$E\$3 on an Excel...

7 Started by myMary  |  Latest comment by lee_dimambro@...

### Highlight Excel list values when they change

February 6, 2013 12:20am PST

Highlight Excel list values when they change article root Excel 2003 Those commands are not available in Excel 2003....or the version I have in work Other formula I think it's better use range...

23 Started by 1000048875  |  Latest comment by ssharkins@...

### EXCEL FORMULA W/O using pivot table

September 7, 2012 2:57pm PDT

EXCEL FORMULA W/O using pivot table Need to sum up the top three costs by brand. As you can see toyota is indicated twice in two different amounts so I would need the formula to rollup brands...

1 Started by Spoofen88  |  Latest comment by Spoofen88

### An alternative Excel averaging formula that doesn't evaluate zero

June 29, 2012 5:10pm PDT

An alternative Excel averaging formula that doesn't evaluate zero article root Good one, thanks Useful. In my Excel manual it include it as: [b]Ignore zeros when averaging[/b]...

2 Started by jonc2011  |  Latest comment by jonc2011

### Three ways to hide zero values in an Excel sheet

June 21, 2012 8:50am PDT

Three ways to hide zero values in an Excel sheet article root Accounting format While it doesn't remove the 0, using the Accounting format with no Symbol. This then shows a "-" instead of a zero....

12 Started by hometoy  |  Latest comment by hws1947@...

### 10 creative uses for Excel's conditional formatting feature

April 16, 2012 9:23pm PDT

10 creative uses for Excel's conditional formatting feature article root Question about your last tip Hi Susan, great tips for Excel users. But what do you mean "This rule is unstable if you use...

2 Started by jberezinski@...  |  Latest comment by mark@...

### Count the number of Excel records that fall between two dates

March 27, 2012 7:07am PDT

Count the number of Excel records that fall between two dates article root pre Excel 2007... you can do this with an array formula: =SUM((A5:A12>=B1)*(A5:A12

11 Started by jbenton@...  |  Latest comment by N / A

### 10 tips for troubleshooting Excel formulas and functions

March 2, 2012 4:04am PST

10 tips for troubleshooting Excel formulas and functions article root Thanks Susan! Your articles are always very helpful, and I wanted to let you know how much I appreciate them. A Second...

7 Started by sissy sue  |  Latest comment by ssharkins@...

### Office challenge: How would you sum every other value in a column?

February 17, 2012 12:18pm PST

Office challenge: How would you sum every other value in a column? article root SUMPRODUCT(MOD(ROW())) is one answer The formula =MOD(B1,2) would return 0 if the number is even and 1 if it's odd,...

11 Started by Darryl~  |  Latest comment by sk.tomar@...

### Scheduling

January 30, 2012 9:51pm PST

Scheduling Hello, Do you take into consideration the AHT, weekly offs, unplanned leaves and annual leaves too? Is there a formula to calculate roughly the number of techs required to support...

1 Started by ds4312@...  |  Latest comment by ds4312@...

### Use Earned Value Management (EVM) to determine project status

November 20, 2011 9:20pm PST

Use Earned Value Management (EVM) to determine project status article root Important EVM formulas Find out important EVM formulas to learn here:...

1 Started by user_786@...  |

### 10 ways to improve Excel performance

November 18, 2011 7:52am PST

10 ways to improve Excel performance article root Congratulations! Great hints, truly helpful! forward referencing "Formulas should always reference forward, to the right or below. Avoid...

23 Started by david.mapelli  |  Latest comment by Rob-dawg!

### Use SUMIFS() to sum by multiple conditions in Excel

November 15, 2011 8:24am PST

Use SUMIFS() to sum by multiple conditions in Excel article root syntax in sumifs Susan: I used the wizard and this is what my formula looked like: "=SUMIFS(\$C\$6:\$C\$13,\$A\$6:\$A\$13,D\$1)". (the...

8 Started by zimmerwoman  |  Latest comment by peter.r7

### Create a dynamic Excel chart and make your own dashboard

October 17, 2011 3:34am PDT

Create a dynamic Excel chart and make your own dashboard article root Dynamic Chart "1.Select A3:A6. 2.Hold down [Ctrl]. 3.Select F3:A6. You just created a non-contiguous selection" I think you...

23 Started by sandra.scrivens@...  |  Latest comment by dljohn7

### Troubleshoot VLOOKUP() formulas gotchas

September 28, 2011 1:11pm PDT

Troubleshoot VLOOKUP() formulas gotchas article root hi hi Match and Index I've pretty much stopped using vlookup over the last few years and now use Match and Index instead. You get more...

7 Started by JohnsLaurel  |  Latest comment by Marshwiggle

### Office challenge: Why aren't my formulas calculating correctly?

September 14, 2011 8:29am PDT

Office challenge: Why aren't my formulas calculating correctly? article root Is it because ... the formula has used absolute cell references e.g. b10 > =SUM(\$b8+\$b\$9) copy/paste or fill/right...

16 Started by nrobinson5@...  |  Latest comment by mrsmithatraytheon

### Five tips for troubleshooting formulas in Excel

September 6, 2011 8:31am PDT

Five tips for troubleshooting formulas in Excel article root Love the info... Hate the blog format I simply don't understand why TR puts this info out by the various authors/correspondents and...

5 Started by rwbyshe@...  |  Latest comment by Jody Gilbert

### Excel Help - copy formula but incrementing column rather than row

August 17, 2011 10:18am PDT

Excel Help - copy formula but incrementing column rather than row I have a standard spreadsheet with 3 tabs which is to be used by several users (not particularly IT savvy ??? so needs to be...

1 Started by alainforbes@...  |  Latest comment by alainforbes@...