Hello,

This is my first post on this forum. Thank you all for your help!

I'm trying to sum data in a cell when data in another sheet meet some criteria. The formula I'm using, which is working, is the following:

=SUM(SUMIFS(Data!$A:$A;Data!$B:$B;MONTH(B$1);Data!$C:$C;{"203*";"204*";"206*";"280*"}))

This formula I want to copy-paste in many other cells but I would like to avoid manually updating the array constant if the values change later. This I could do it with a named range (via Define name) but it is not straightforward to see which values are being used when there are many rows. I would prefer to have a column with cells containing these values for each row and somehow having them converted to an array constant. Is this possible?

I would prefer a solution which does not use VisualBasic as other users will use this file.

Thank you in advance!

Llorenc