Forum Discussion
How to Bold Amount in text formula in excel & Subtotal in Table
The formula for the subtotal is available in your sheet (Cell E70), you only need to insert a filter in your table and the subtotal is automatically counted.
=SUBTOTAL(109,[Amount])
The formula for the subtotal is available in your sheet, you only need to insert a filter in your table and the subtotal is automatically counted Enclosed the file as it is, only with additional filters, you can filter as you like by column and only the filtered one is counted, or if you do not filter the total sum.
Thank you for your understanding and patience
I wish you much success in your project
NikolinoDE
I know I don't know anything (Socrates)
- Respect NikolinoDE,
My question is that every break page I want subtotal. Example I have 2 pages I want 1st page subtotal and last page I want to grand total. thanks=SUM(SUBTOTAL(109,E7:E69,M7:M69))+0*NOW()
Existing area in your file: E7:E69
Imaginerer second area: M7:M69
The additional expression "+ 0 * NOW ()" always causes a recalculation of the two functions carried out if something changes in the worksheets, especially if the F9 key (= recalculation) is pressed.
Thank you
Nikolino
I know I don't know anything (Socrates)
- please take print preview of my page on 1st page end ag E42 so I want subtotal ist here E42 in this table. 2nd E69 I want to Gand Total that its. Sir.