Merry Christmas, everybody.
I have a sheet with about 50 countifs. Theese countifs contain 7-8 criterias. 6-7 of theese criterias are identical. Now I want to add another criteria. The way I do it today, it means alot of copy-paste.
So, is it possible to write each of the criterias in a cell, and then just reffer to the cell in the countifs?
Also, I guess it might exist an easier solution to this, but this is what I'm able to figure out by myself with my Excel skills
Thanks.
I have a sheet with about 50 countifs. Theese countifs contain 7-8 criterias. 6-7 of theese criterias are identical. Now I want to add another criteria. The way I do it today, it means alot of copy-paste.
So, is it possible to write each of the criterias in a cell, and then just reffer to the cell in the countifs?
Also, I guess it might exist an easier solution to this, but this is what I'm able to figure out by myself with my Excel skills

Thanks.