# ignore errors

1. ### Ignore error on pivot table filtering

Dear all, I have two pivot tables on one worksheet, one for the input and one for the output of material. Both are based on different tables and have two filters for year and period of the year. On another sheet I can select a year and a period, hit a button and the filter of both pivot tables...
2. ### Sumproduct equivalent for Aggregate dealing with #VALUE results in column

How would one write a formula to do what, for example, =AGGREGATE(1,7,NovDataTable[Inc Closed Date - Inc Date]) does? I have a data table called NovDataTable and want a formula to get the average values in the table column [Inc Closed Date - Inc Date], without resorting to the aggregate...
3. ### How do you tell Excel to resume recognizing errors?

There is 1 section of my code where errors don't matter. I would like to use On Error Resume Next However, for the rest of the code, I'd like it to go back to recognizing errors. === More detail: My code is copying the "Policies" worksheet and creating a "Policies2" worksheet. I want to...
4. ### Error proof Average?

Hi, Trying to average column of numbers based on a monthly basis. The date column B is in ascending order, data to average is in column D. The formula I am using in G7 is...
5. ### How can I use "SumIF" to ignore error cells, but add up non-continuous cells?

Hello! I'm a very frustrated beginning excel user and could use your help! I've read the posts regarding using SumIF to ignore error cells when adding a group of cells, but when I try to use the formula I get an error. I think it's because I'm trying to add cells that are not continuous...
6. ### Sum Every Other Cell -Ignoring Errors in Range

Hi, I am unable to come up with a simple formula that will sum every other cell in a row AND ignore any error messages that may occur. Numbers are always positive. For this case: <TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=640 border=0...
7. ### Find Smallest Non-Zero Value in Column

Hi, Having a difficult time finding the difference between the maximum number and the smallest non-zero value that ignores text and any error messages. What I need to do is subtract the Maximum value in the column from the smallest non zero value. In the case below, it should take 7 minus 5...