How to SUMIFS multiple Non-Contiguous columns
=SUM(
CHOOSE({1,2,3},
INDIRECT(J4),INDIRECT(J5),INDIRECT(J6)
)
*(Suppliers=J2))
See comment for Full video
....
Follow for more tips
....
#Excel #Cheatsheet #programminghelp
=SUM(
CHOOSE({1,2,3},
INDIRECT(J4),INDIRECT(J5),INDIRECT(J6)
)
*(Suppliers=J2))
See comment for Full video
....
Follow for more tips
....
#Excel #Cheatsheet #programminghelp
جاري تحميل الاقتراحات...