It is because my routine work is such that I am used to hide rows temporaly by “grouping tool” and when I unhide the rows, I don’t want to sum include privously hidden rows which now are visible.
But thank you for your answer. It can solve part of my problem and I learned from your answer some Built in excel function that I didn’t know before.