Calculate Variable Average With Slicer

[soubasa]

Hello,
I have 7 variable number, I need calculate average of numbers.
as default sum 7 number and devide by 7
sometimes I need ignore one number and sum 6 number and devide by 6
sometimes I need ignore two number and sum 5 number and devide by 5
position of numbers that I need to ignore them are variable or dynamic
is it possible I do it with slicer?, I mean I need to filter or turn off ignore numbers

could you please help me for do that?
thank you in advance.

[dosydos]

Easiest way would be to use a helper column in column c. For every number you want include just put an x in column c.
then just use an averageif() function.
See attached workbook.

[soubasa]

Awesome
Thank you very much
when I want to ignore number, I have to delete it and type it again or back the change with CTRL + Z
is it possible do it with slicer or something else for delete or hide ignore number? "hide number or delete it and comeback number again without type it or use of CTRL + Z"

[dosydos]

to ignore number delete the x in the appropriate cell. To add it back you can just put an x in again. Of course CTRL+Z could work depending on if you did any actions inbetween.

[dosydos]

actually another option is attached below.
Turn your data into a pivottable. Then utilize an actual slicer. You can CTRL + CLICK to select or deselect multiples which will hide and autocalculate on the pivot for you.

[soubasa]

Your the best



Please Accept My Deepest Thanks

[dosydos]

Glad to help and thank you for the rep