How to Create Page wise Dynamic Totals for All Pages on Excel in Tamil | Prabas MS Office

[@Prabasmsoffice]

Welcome all, the practice file is saved in our usual path: www.prabastech.in/free-downloads/

[@sridharangounder8569]

your explanation is very good. Cheers.

[@Prabasmsoffice]

Thanks for your comment.

[@prasanthlingareddy517]

hi sir very useful your formulas and concepts thanks a lot but i have dought the unequal row how to use the mod function

[@lathaajish5234]

Explained very well. Thank you sir.. But how to carry forward total to each page

[@Prabasmsoffice]

I will try to make a dedicated video. Thanks.

[@apn6824]

Excellent Prabhakar...I heard in another tutorial that column width or row height simply describes the particular cell..Is it true ?. And pls give a new video on new LET function and SOLVER function. Everyday we are learning a lot from you.God bless..

[@Prabasmsoffice]

I will try to answer your questions in the future videos. Thanks.

[@mhn3105]

Good concept and well explained. if suppose we use Autofit Row height, the no. of rows in a page may not be constant. Is there any other way to find the last row of the page?

[@amalarajmstella2340]

Thank you sir nicely explain it super really vary interesting

[@Prabasmsoffice]

Appreciate your interest for learning this concept. Happy learning.

[@prabhakarandhanavel483]

thanking you sir, since last week follow your videos. sir how to get sum of month wise data from date wise data without pivot table .

[@Prabasmsoffice]

Try to use Sumif

[@dm-zd5nu]

learn new concept sir. i will try it now

[@Prabasmsoffice]

Appreciate your interest for learning this concept. Happy learning.

[@lathakannan7812]

THANKYOU, can i get the page wise total under the amount column sir? (same column)

[@Prabasmsoffice]

Sure, I will try to make.

[@sathyanarayanansatagopan9069]

Sir, please explain date wise debit and credit total and balance in next line.

[@ahamedrassath]

It's possible to print title or address at the bottom like page repeated at top

[@k.sriyogabharathi7408]

Thanking you very much Can I get the page wise total under the amount of column?

[@Prabasmsoffice]

There would be a workaround for your question, I will try to make a video for that. Thanks.

[@madhanganesh16]

Good concept and we'll explain...but supposed we used header column on each page,the no.of rows in a page may be cannot constant, if any another way to find the last row of the page?

[@Prabasmsoffice]

The combination of IF MOD ROW SUM OFFSET works only for this concept where we have the equal row height for all rows. I will try to cover your question in the future videos. Thanks.

[@AduthuraiNatureCure]

M.Saravanan: 👌👍

[@Dineshkumar-gz7vh]

Sir I am in civil field I have to enter Daily Report for many sites and weekly report how to link my daily report to weekly report of all data

[@gowtham.s5431]

Bro how to s et over all page total in excel for ex 1/10 if i filter and take it print but total page 42 but if i selct iy 1 of 10 only but i need if i fliter also1/ 42 if nex one select the print 11/42 but strat it 1

[@ErusappanRagupathi]

Sir i am tryed. First page come . Correct. Next total comes to next two rows sir. What will do sir i am used 2075Rows sir .

[@sivakumarramanathan2251]

I want a consolidated report to be printed in the last page under the headings as page 1 total, page 2 total... Lastly Grand total. Is it possible? 🙏

[@thottaniketta2725]

How I will hide formula but I can do entry same sheet .formula cell only show value don't show formula when ever click formula cell

[@Prabasmsoffice]

Watching the entire playlist can teach you the answer for your question. If you need more support, contact me at 9940261814

[@rajasanthosh9617]

Super sir

[@babups2904]

Very Nice i am not understanding sirr

[@kroobanraj2299]

Thank u sir Then grand total sir

[@Prabasmsoffice]

Sure. Hope this video helps you Rooban Raj.

[@gokulgovindanclusterhead9392]

We have got pagewise total, what about last page total if it falls short of the described height

[@Prabasmsoffice]

I will try to explain your question in the future videos, stay tuned

[@sattech8878]

THANK U SIR

[@jayarajk6570]

How to Calculate uneven Row high t

[@Prabasmsoffice]

This concept works only on even height rows... For uneven rows, I will try to publish a video. Stay tuned.

[@arockiarajvanathaiya6140]

Hi, how insert excel data sheets in pagemaker to make a book

[@Prabasmsoffice]

Your question is not in the scope of our service. But I will try to make a video for your question. Please stay tuned by subscribing to prabas ms office.

[@dakshinamurthym8970]

பல செல்களில் உள்ள தொகைக்கு அந்த பக்கத்தின் கடைசி ரோவில் அந்தந்த காலத்தில் அந்த பக்கத்துக்கு உண்டான தொகையை கொண்டு வருவது எப்படி?

[@Prabasmsoffice]

We will make one video

[@suvamani]

How to make dashboard

[@suvamani]

Can u teach me

[@Prabasmsoffice]

One video is coming today

[@manoharanchinnasamy3192]

Formula enter செய்யும்போது சற்று ஜீம் செய்து காட்டினால் நல்லது

[@Prabasmsoffice]

அடுத்த வீடியோவில் இன்னும் ஜூம் செய்து பதிவிடுகிறேன். உங்கள் ஆலோசனைக்கு நன்றி.

[@devotionalsongs4327]

Oru sheet la erukura data va change pannum pothu entire sheet la change aaganum . But don't use Find and Replace sir

[@Prabasmsoffice]

Generally it is posible.

[@devotionalsongs4327]

Athoda Procedure ra sollunga sir

[@JatinKumar-yc1ij]

auto captions failed to translats tamil language. please provide english subtotlas. i am not able to understand a single word

[@sathyanarayanansatagopan9069]

Sir, please explain date wise debit and credit total and balance in next line.