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

Deleted user · 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

Products By Bayt.com

Use Our Mobile App

Start networking and exchanging professional insights

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

Popular Searches

More Questions Like This