Name Range - Relative Reference

Originally Posted by benishiryo

hi Sultix, you can try:
=SUMIFS(INDIRECT("Class"&COLUMNS($C10:C10)),TYP,$B10)

in fact, SUMIF is sufficient

Thanks works now with attached file.