Hi,
How do I correct this formula? I have tried various ways and it's not working. I think it may be invalid :)
=SUM(SUMIFS('MF Customer Level'!$T$2:$T$11243,'MF Customer Level'!$B$2:$B$11243,'Detailed Analy'!J$7,'MF Customer Level'!$J$2:$J$11243,'Detailed Analy'!$A8))&(SUMIFS('Usage Customer Level'!$K$2:$K$4566,'Usage Customer Level'!$B$2:$B$4566,'Detailed Analy'!J$7,'Usage Customer Level'!$C$2:$C$4566,'Detailed Analy'!$A8))
Thanks
Solved by D. J. in 30 mins