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

1. ## 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

2. ## Re: How to get an AVERAGEIFS formula to not include cell in average, by triggering switch?

With that in mind, try this
Formula:
`Please Login or Register  to view this content.`

3. ## Re: How to get an AVERAGEIFS formula to not include cell in average, by triggering switch?

Sorry about that. The correct one is now attached.

Not that is matters much anymore, because your recommendation worked perfectly :-)

Gawd! I love this site!!!!

Thank you so much Craig! Hope you have a great day.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1