Here you go. Press Ctrl+F3 to open the name manager. You'll see three named ranges, one for each column in the data. The ranges are defined via formulas that for Column A looks like:
I've used these three named ranges in the formula (yellow cell) that resembles that your formula.
Add/remove data that matches the criteria used (green cells) and you'll see that the ranges expand/contract to match.
Note you don't have to create a named range for every column, just the ones you wish to use in formulas.
You could also achieve the same with the use of tables.
BSB
Bookmarks