using sum & sumifs with a named range

[jynxy]

Hi,

i have this formula which works fine

=200-(SUM(SUMIFS(B6:B405,E6:E405,{"h","ld","u","f"})))

what i need is {"h","ld","u","f"} to be a named range, so that values can be added in on a later date if needed. from what i can is this is not possible is that correct?

Thanks

 

[Fluff]

Glad to help & thanks for the feedback.