Hi,
The simplest, but admittedly not the most elegant is
L3:
Formula:![]()
=SUMIF(A2:A7,K2,B2:B7)+SUMIF(C2:C7,K2,D2:D7)+SUMIF(E2:E7,K2,F2:F7)+SUMIF(G2:G7,K2,H2:H7)+SUMIF(I2:I7,K2,J2:J7)
There's no doubt also an array formula out there.
Hi,
The simplest, but admittedly not the most elegant is
L3:
Formula:![]()
=SUMIF(A2:A7,K2,B2:B7)+SUMIF(C2:C7,K2,D2:D7)+SUMIF(E2:E7,K2,F2:F7)+SUMIF(G2:G7,K2,H2:H7)+SUMIF(I2:I7,K2,J2:J7)
There's no doubt also an array formula out there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks