I feel stuck on an issue of which I am sure I will not find the answer because I might not have the right terms for my research on the search engine and it is rare that I am in such a blockage. However, here is my issue: on another sheet i want to get a sum of value. On the picture below you can see few blocks represented by green circles and each block has a cell with check box in red circle and a value to get append to a sum by a blue circle. And this what i want, i want to get in my sum each blue circle value only if in the same block the check box is checked. This seem easy but my issue isn't there. I could get a condition if the check box is checked take the value for each block but maybe i want more block. This is my issue, i could get more block or someone else could get more or less block. image

So i need a formula dynamic to get each future value in blue circle where futur red circle could be checked.

I hope my issue could be understand.

CodePudding user response：

try:

=SUM(FILTER(R7:R100; W4:W97=TRUE))