I attach an example and the explanation.
Basically i have a workbook with, 52 sheets, one per week. within the week table, each day is composed of three columns: quantity, type, name (so 7 days *3 columns)
I want to sum the "quantities" of the week for each "name" (each name is in a list of names)
I'm using sumifs but it's very long. Is there a way to make the formula shorter (I will have to use it in each sheet and in a summary sheet)
(please not macros)
=SUMIFS(B:B;D:D;"="&X2)+SUMIFS(E:E;G:G;"="&X2)+SUMIFS(H:H;J:J;"="&X2)+SUMIFS(K:K;M:M;"="&X2)+SUMIFS(N:N;P:P;"="&X2)+SUMIFS(Q:Q;S:S;"="&X2)+SUMIFS(T:T;V:V;"="&X2)
thank you
Bookmarks