Formula optimization

[Pierre]

Hello,

I have a file for calculating number of tranport per transport company. There are lots of formula inside that can make the file a bit slow. I was wondering if there was any a way to improve/change the formula inside so that the calculations and updates would be quicker.
For example, I was thinking to change the "countifs" by "sumproduct"?
Any help is welcome

 

[Pierre]

Hmm I have an error when updloading the file... :s

 

[Khalid NGO]

Hi Pierre,

Optimization can be proceed after having your file.
I am having no difficulty in uploading.
Here is a test upload (blank file)

 

[Pierre]

Something is wrong somewhere, I tried even with a blank file, I have the "There was a problem updloading your file" error message...
I tried to restard computer but it's still the same...

 

[Pierre]

Seems problem was with Firefox, I connected with IE, now I can upload the file

 

[Khalid NGO]

Thanks for the file...

Can you check the result after limiting all your ranges?
For example:

=COUNTIFS('Подтверждение день'!$D2:$D1000,$AO$11,'Подтверждение день'!$L2:$L1000,$AQ$3,'Подтверждение день'!$S2:$S1000,$AQ$2)

Regards,