Extended M1 sum rule for excited symmetric and mixed-symmetry states in nuclei