How to get an AVERAGEIFS formula to not include cell in average, by triggering switch?

Hi All,

The "Descriptive Title" may be a little confusing so let me explain.

What I am trying to do is to not include a particular cell within the calculation of a formula, by triggering an event/switch, such as placing a '1' in the adjacent cell. Still confused :confused:, lol, me too!

Within the attached spreadsheet go to the "Overall Stats" tab. If you click on any of the cells (C3:C8), you will see the formula currently being used to calculate the average for each employee. Here is the formula from cell C3:

Please Login or Register  to view this content.

This formula is pulling its information from the "Response Times" sheet. Now in some cases, I will need to...basically tell the formula not to include a particular cell in it's calculation. And I would like to be able to do so by placing the number '1' in another cell, but in the same row that corresponds to the value in column A.

So if you go to the 'Response Times' sheet within the attached workbook, you will see that I have placed a '1' in cell E63. When doing this, I would like for the formula (In cell C3 on sheet 'Overall Stats') to exclude cell A63 , from its calculations.

Thanks,
Chris

The attached spreadsheet does not match the references in your post.
With that in mind, try this

Formula:

Please Login or Register  to view this content.