Sumproduct too long

[ahamed982]

Hi everyone,

This is my first thread at chandoo, I am getting a message as sumproduct formula is too long. Please advice how can I over come with an alternative formula for the below;

=SUMPRODUCT((--(MONTH(A4:A10000)=Q2)),(--(B4:B10000=P3)),G4:G10000)


Thank you in advance

 

[Hui]

Ahamed982
You could try

1. Reducing 10,000 to the extent of your data
2. Changing the formula to: =SUMPRODUCT((MONTH(A4:A10000)=Q2)*(B4:B10000=P3)*(G4:G10000))
3. Trying the Sumifs() or Product() functions
4. Uploading the file here so we can see what is going on

 

[ahamed982]

Dear Hui

Thank you for the instructions. I may use the entire 10,000 rows, therefore I have no option other than to keep that extent. I suppose sumif wont work when I am to match dates with month {MONTH(A4:A10000)=8} & to convert numeric {--} to get the monthly total. I am not sure how product() would work, let me try anyway.

Thanks once again.

 

[Haseeb A]

Hello Ahamed,

Take a look on DSUM function.