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 column L. If there is no match, November column J = November column L.
I‘ve attached screen shot of a mocked up template, I can‘t share the real one due to it being a work document with protected info. But the months cover the span of the year and as clients get added to or taken away from the list, I need a way to accurately, and automatically calculate the year-to-date total spent.
Thank you! This is well beyond my Excel skills
Platform: Excel 365I 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 column L. If there is no match, November column J = November column L. I’ve attached screen shot of a mocked up template, I can’t share the real one due to it being a work document with protected info. But the months cover the span of the year and as clients get added to or taken away from the list, I need a way to accurately, and automatically calculate the year-to-date total spent. Thank you! This is well beyond my Excel skills Read More
