ignore zeros

  1. C

    Ignore zero values in pivot chart

    Hi there, Background: I have a data set for a call centre that displays each staff member's daily call numbers across two different call types (Call Type 1, Call Type 2) - staff only work on one particular call type each day. I would like to create two pivot charts, one with...
  2. M

    Average formula to ignore zeros over several tabs of data (in 1 spreadsheet)

    I have 12 tabs (1 for each month or period) in a spreadsheet and am trying to create a formula to give me an average from tab to tab but to ignore the 0.00%. (So the Period 2 tab needs average Pd1 & 2; the Period 3 tab needs average Pd1,2 & 3; and so and and so forth until Period 12 which needs...
  3. R

    Win Percentage

    I am very new to Excell and looking to set up a spreadsheet that keeps track of an office football pool and measures win percentage. This is easy if everyone plays every week. But this is not the case. The formula I would need to use would have to ignore weeks where a particular person...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top