Dec 29 2008

Sum Values in a Range While Ignoring #N/A

Excel provides an easy way to sum a range of cells based on a given criteria. ¬†There are many ways this can be used but the example we are going to look at today is summing a range while ignoring #N/A’s in the same range. ¬†Without ignoring #N/A, the result of the sum will be […]

May 3 2007

Sumif and Countif Formulas in Excel

There are many times when analyzing large amounts of data when you might want to sum or count a column or range based on certain criteria. One example is if you have a database of products you have sold, you might want to know the sum of profits for a particular product – which is […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives