Forum Discussion
Excel
Good afternoon, the situation is like this. The accountant of the company keeps the Excel book (it is not known in which version of the program). Sends this book and opens it already on the MacBook. But where the SUMIFS function is used instead of the desired values, just zeros appear. What could be the cause of this problem?
7 Replies
Do I understood correctly
- all calculations work on unknown version of Excel and on unknown platform (Windows or Mac or web, what ever);
- for the same workbook opened on MacBook only SUMIF() doesn't return result, all other functions work as expected
Ну неизвестна именно версия Офиса, ОС Windows 10.
Спасибо. Но больше интересует только эта формула не работает или все остальные тоже. Если все, то скорее всего как Martin_Weiss посоветовал. Если только SUMIFS() то лучше формулу посмотреть, возможно даты, если они там есть, подхватываются некорректно.
Hi Dmitry2450
maybe the recalcutlation on that Macbook is set to manual?
Check in the Excel options and change it to "Automatic"
- Thanks for the advice, I will check this moment!
