Home

Настройки автосуммирования

%3CLINGO-SUB%20id%3D%22lingo-sub-1095570%22%20slang%3D%22en-US%22%3E%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%B0%D0%B2%D1%82%D0%BE%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095570%22%20slang%3D%22en-US%22%3E%D0%94%D0%BE%D0%B1%D1%80%D0%BE%D0%B3%D0%BE%20%D0%B2%D1%80%D0%B5%D0%BC%D0%B5%D0%BD%D0%B8%20%D1%81%D1%83%D1%82%D0%BE%D0%BA!%3CBR%20%2F%3E%D0%92%D1%8B%D0%B4%D0%B5%D0%BB%D1%8F%D1%8E%20%D1%86%D0%B8%D1%84%D1%80%D1%8B%20%D0%B2%20%D1%81%D1%82%D0%BE%D0%BB%D0%B1%D1%86%D0%B5%20%D0%B8%20Excel%20%D0%BF%D0%BE%D0%BA%D0%B0%D0%B7%D1%8B%D0%B2%D0%B0%D0%B5%D1%82%20%D1%81%D1%83%D0%BC%D0%BC%D1%83%20%D0%B2%20%D0%BD%D0%B8%D0%B6%D0%BD%D0%B5%D0%B9%20%D1%87%D0%B0%D1%81%D1%82%D0%B8%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%2C%D0%BA%D0%BE%D1%82%D0%BE%D1%80%D0%B0%D1%8F%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BE%D1%82%20%D1%84%D0%B0%D0%BA%D1%82%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%BE%D0%B9%20%D0%BD%D0%B0%20%D1%81%D0%BE%D1%82%D1%8B%D0%B5%20%D0%B4%D0%BE%D0%BB%D0%B8!%20%D0%92%D0%BE%D0%BF%D1%80%D0%BE%D1%81%3A%20%D0%9A%D0%B0%D0%BA%20%D0%B7%D0%B0%D0%BB%D0%B5%D0%B7%D1%82%D1%8C%20%D0%B2%20%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%2C%D1%87%D1%82%D0%BE%D0%B1%20%D0%BF%D0%BE%D0%B2%D1%8B%D1%81%D0%B8%D1%82%D1%8C%20%D1%82%D0%BE%D1%87%D0%BD%D0%BE%D1%81%D1%82%D1%8C%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1095570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1095670%22%20slang%3D%22en-US%22%3ERe%3A%20%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%B0%D0%B2%D1%82%D0%BE%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1095670%22%20slang%3D%22en-US%22%3E%3CP%3EEnglish%20translation%20is%20needed%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509664%22%20target%3D%22_blank%22%3E%40Utavegu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096300%22%20slang%3D%22en-US%22%3ERe%3A%20%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%B0%D0%B2%D1%82%D0%BE%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509664%22%20target%3D%22_blank%22%3E%40Utavegu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%D0%A2%D1%83%D0%B4%D0%B0%20%D0%BD%D0%B8%D0%BA%D0%B0%D0%BA%20%D0%BD%D0%B5%20%D0%B7%D0%B0%D0%BB%D0%B5%D0%B7%D1%82%D1%8C%2C%20%D0%BE%D0%BD%D0%B8%20%D0%BA%D0%B0%D0%BA%D0%B8%D0%B5%20%D0%B5%D1%81%D1%82%D1%8C.%20%D0%90%20%D0%BE%D1%82%D0%BA%D1%83%D0%B4%D0%B0%20%D0%B8%D0%B7%D0%B2%D0%B5%D1%81%D1%82%D0%BD%D0%B0%20%D1%84%D0%B0%D0%BA%D1%82%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B0%D1%8F%20%D1%81%D1%83%D0%BC%D0%BC%D0%B0%2C%20%D0%BE%D0%BD%D0%B0%20%D0%B3%D0%B4%D0%B5%20%D0%B8%20%D0%BA%D0%B0%D0%BA%20%D0%B2%D1%8B%D1%87%D0%B8%D1%81%D0%BB%D1%8F%D0%BB%D0%B0%D1%81%D1%8C%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098146%22%20slang%3D%22en-US%22%3ERe%3A%20%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%B0%D0%B2%D1%82%D0%BE%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%D0%9F%D1%80%D0%B8%D0%B2%D0%B5%D1%82%D1%81%D1%82%D0%B2%D1%83%D1%8E!%3C%2FP%3E%3CP%3E%D0%95%D1%81%D1%82%D1%8C%20%D1%81%D1%82%D0%BE%D0%BB%D0%B1%D0%B8%D0%BA%20%D1%86%D0%B8%D1%84%D1%80.%20%D0%92%20%D0%BE%D0%B4%D0%BD%D0%BE%D0%B9%20%D1%8F%D1%87%D0%B5%D0%B9%D0%BA%D0%B5%20%D1%81%D1%82%D0%BE%D0%B8%D1%82%20%D1%84%D0%BE%D1%80%D0%BC%D1%83%D0%BB%D0%B0%20%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%20%D1%8D%D1%82%D0%B8%D1%85%20%D1%86%D0%B8%D1%84%D1%80.%20%D0%A2%D0%B0%D0%BC%20%D0%BE%D1%82%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D1%81%D1%83%D0%BC%D0%BC%D0%B0.%20%D0%9A%D0%BE%D0%B3%D0%B4%D0%B0%20%D0%B2%D1%8B%D0%B4%D0%B5%D0%BB%D1%8F%D0%B5%D1%88%D1%8C%20%D1%81%D1%82%D0%BE%D0%BB%D0%B1%D0%B8%D0%BA%20%D1%8D%D1%82%D0%B8%D1%85%20%D1%86%D0%B8%D1%84%D1%80%2C%20%D1%82%D0%BE%20%D0%B2%20%D0%BD%D0%B8%D0%B6%D0%BD%D0%B5%D0%BC%20%D0%BF%D1%80%D0%B0%D0%B2%D0%BE%D0%BC%20%D1%83%D0%B3%D0%BB%D1%83%20%D0%BE%D1%82%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D1%81%D1%83%D0%BC%D0%BC%D0%B0%20%D0%B2%D1%81%D0%B5%D1%85%20%D0%B2%D1%8B%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D1%8B%D1%85%20%D1%86%D0%B8%D1%84%D1%80.%20%D0%98%20%D0%B2%D0%BE%D1%82%20%D1%8D%D1%82%D0%B8%20%D0%B4%D0%B2%D0%B5%20%D1%81%D1%83%D0%BC%D0%BC%D1%8B%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D1%8E%D1%82%D1%81%D1%8F%20%D0%BD%D0%B0%20%D0%BD%D0%B5%D1%81%D0%BA%D0%BE%D0%BB%D1%8C%D0%BA%D0%BE%20%D1%81%D0%BE%D1%82%D1%8B%D1%85.%20%D0%AF%20%D0%BF%D0%BE%D0%BD%D0%B8%D0%BC%D0%B0%D1%8E%2C%20%D1%87%D1%82%D0%BE%20%D1%8D%D1%82%D0%B0%20%D1%80%D0%B0%D0%B7%D0%BD%D0%B8%D1%86%D0%B0%20%D0%B2%D1%8B%D0%B7%D0%B2%D0%B0%D0%BD%D0%B0%20%D1%80%D0%B0%D0%B7%D0%BD%D1%8B%D0%BC%20%D1%82%D0%B8%D0%BF%D0%BE%D0%BC%20%D0%BE%D0%BA%D1%80%D1%83%D0%B3%D0%BB%D0%B5%D0%BD%D0%B8%D1%8F%2C%20%D0%BD%D0%BE%20%D0%BA%D0%B0%D0%BA%20%D0%B5%D0%B5%20%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B8%D1%82%D1%8C%20-%20%D0%B2%D0%BE%D0%BF%D1%80%D0%BE%D1%81.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098403%22%20slang%3D%22en-US%22%3ERe%3A%20%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%B0%D0%B2%D1%82%D0%BE%D1%81%D1%83%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509664%22%20target%3D%22_blank%22%3E%40Utavegu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%D0%9F%D0%BE%20%D0%B8%D0%B4%D0%B5%D0%B5%20%D0%B8%20%D1%82%D0%B0%D0%BC%20%D0%B8%20%D1%82%D0%B0%D0%BC%20%D0%BE%D0%B4%D0%BD%D0%B0%20%D0%B8%20%D1%82%D0%B0%20%D0%B6%D0%B5%20SUM()%20%D0%B4%D0%BE%D0%BB%D0%B6%D0%BD%D0%B0%20%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%B0%D1%82%D1%8C.%20%D0%A2%D0%BE%2C%20%D1%87%D1%82%D0%BE%20%D0%B2%20%D1%81%D1%82%D0%B0%D1%82%D1%83%D1%81%D0%B5%20%D0%BF%D0%BE%D0%BA%D0%B0%D0%B7%D1%8B%D0%B2%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%B6%D1%91%D1%81%D1%82%D0%BA%D0%BE%20%D0%B7%D0%B0%D1%88%D0%B8%D1%82%D0%BE%20%D0%B8%20%D0%BD%D0%B8%D0%BA%D0%B0%D0%BA%20%D0%BD%D0%B5%20%D0%BD%D0%B5%20%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%B0%D0%B8%D0%B2%D0%B0%D0%B5%D1%82%D1%81%D1%8F.%20%D0%90%20%D0%BC%D0%BE%D0%B6%D0%BD%D0%BE%20%D0%BD%D0%B5%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%BE%D0%B9%20%D1%84%D0%B0%D0%B9%D0%BB%20%D1%81%20%D0%BF%D1%80%D0%B8%D0%BC%D0%B5%D1%80%D0%BE%D0%BC%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Доброго времени суток!
Выделяю цифры в столбце и Excel показывает сумму в нижней части экрана,которая отличается от фактической на сотые доли! Вопрос: Как залезть в настройки суммирования,чтоб повысить точность?
4 Replies
Highlighted

English translation is needed @Utavegu 

@Utavegu 

Туда никак не залезть, они какие есть. А откуда известна фактическая сумма, она где и как вычислялась?

Highlighted

@Sergei Baklan Приветствую!

Есть столбик цифр. В одной ячейке стоит формула суммирования этих цифр. Там отображается сумма. Когда выделяешь столбик этих цифр, то в нижнем правом углу отображается сумма всех выделенных цифр. И вот эти две суммы отличаются на несколько сотых. Я понимаю, что эта разница вызвана разным типом округления, но как ее настроить - вопрос.

Highlighted

@Utavegu 

По идее и там и там одна и та же SUM() должна работать. То, что в статусе показывается жёстко зашито и никак не не настраивается. А можно небольшой файл с примером?