Forum Discussion
Solved
Sum formula across sheets with matching column
Platform: Excel 365 I need Columns A, B, C and E to match in both October and November sheets. If they match, then October column L is added to November column J, the result is shown in November col...
In L2:
=J2+IFERROR(INDEX(October!$L$2:$L$100, XMATCH(1, (October!$A$2:$A$100=A2)*(October!$B$2:$B$100=B2)*(October!$C$2:$C$100=C2)*(October!$E$2:$E$100=E2))), 0)
Adjust the ranges if the October data extend below row 100.
Fill down.
In L2:
=J2+IFERROR(INDEX(October!$L$2:$L$100, XMATCH(1, (October!$A$2:$A$100=A2)*(October!$B$2:$B$100=B2)*(October!$C$2:$C$100=C2)*(October!$E$2:$E$100=E2))), 0)
Adjust the ranges if the October data extend below row 100.
Fill down.
HansVogelaarTHANK YOU! That appears to be working just like intended. Thak you so much!