Your formula for Q1 is:
=SUMPRODUCT(('EZE DATA'!$M$2:$M$1962)*('EZE DATA'!$D$2:$D$1962="ACTNS")*('EZE DATA'!$E$2:$E$1962="LatAm")*('EZE DATA'!C2:CC22000="Q1"))
Looking at the bit for Q1:
'EZE DATA'!C2:CC22000
I'd say you have a typo and this should be
'EZE DATA'!$C$2:$C$1962
When using sumproduct I'd suggest it's normally a good idea to keep the arrays the same size...
Bookmarks