Dec 29 2008
Sum Values in a Range While Ignoring #N/A
- Comments Off
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
- Comments Off
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 […]