How to get the sum of a row along with some hidden figures in Excel?

Question

With the same formula, Sum of the row should be changed; whether we show/hide few other figures.

Ansab Khan · Answer

select the range, and hit Alt + = from keyboard

Evans Otalor · Answer

Assuming the data you want to add is in A1 to A10 with A7 to A9 hidden.
Just do a SUBTOTAL 9 and select range A1 to A10 =SUBTOTAL(9, A1:A10) This will add all values in A1 to A10 including the hidden values.

: اسماعيل محمود · Answer

تظليل الصف ثم الضغط على زر sum فى شريط الادوات

mohamed kajji · Answer

choose the cell that will contain the result then, enter "=sum( - select the row -)" and click enter

Utilisateur supprimé · Answer

When using the square or PTT interval when developing the required figures

Ahmad Hussam Malek · Answer

using SUBTOTAL(109, Range) will give you more exact results better than Subtotal (9, Range) please see this article and you will be happy 
http://chandoo.org/wp/2010/02/09/subtotal-formula-excel/

Osama Elazzeh , CMA, MBA · Answer

Just a small formula should cover this make a SUM for the Raw Ex.
=SUM(A22:K22) and then do a plain add of the cell Ex.
=SUM(A22:K22)+F12+F14+F15 , even if the cells are hidden the formula will calculate

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

How to get the sum of a row along with some hidden figures in Excel?

Recherches Populaires

More Questions Like This