Exclude Hidden Rows from Sum | Sumif and Sumproduct Function

Exclude Hidden Rows from Sum | Sumif and Sumproduct Function
Excel Tips & Tricks Playlist Link - drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#excelhidden #exceltrickshidden #innozant #sumproducthiddenrows #sumifhiddenrows #excelformulaandfunction

[@shrikantbadge3978]

Oh my God kitna detail me batate hai sir aap. Ye 2 minute maggi noodle shortcut wali generation nahi samajhti ki real study aise hi hoti hai in details. Thanks a ton!

[@Innozant]

Thanks Shrikant Ji..😊

[@tschulz]

Thank you so much -- I didn't understand a single word (what language are you speaking?), but the universal language of logic and math seems universal. The trick using SUBTOTAL in a whole new column is GREAT. The built-in functions don't cover what I wanted to do: calculating an IRR over a subset of rows.

[@Innozant]

Dear Thomas ,This channel is for HINDI language audience,Will try to add subtitles in English . Thanks for your valuable time

[@atulshukal4072]

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

[@Innozant]

Thanks Atul Ji

[@pramodbhavsar4488]

Very nice example of hidden raws sum with two function explain by you it is useful to me thank you sir

[@Innozant]

Thanks Pramod Ji..Have a great day

[@SunilYadav-jc2ux]

Thanku sir apse kai bar ye question puch chuka tha finally 23 video dekhne ke bad ye video mili thanku

[@Innozant]

ohk..Thanks dear Sunil Ji..Happy learning dear

[@puneetp5967]

Sir
also it very useful for filter option
thanx🙏🙏

[@jayantabhattacharyya628]

Dear Sir
Amazing excel tricks to perform sum excluding hidden rows. I haven't the idea that SUBTOTAL function can be applied excluding hidden rows. Thanks for uploading small but useful tutorial.
Thanks
Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta for this valuable appreciation,Have a great day ahead

[@ajinkyashinde1778]

Superb sir..you are unique as always. Last 2 min lines just touch the heart and mind too ❤️❤️❤️❤️🙏👍👍

[@Innozant]

Thanks Ajinkya ji.God bless you.Happy learning dear .

[@aaditalks9368]

Thank you so much sir aap ki class se kaphi halp hoti h

[@Innozant]

Thanks dear❤️❤️gid bless you

[@souravdebnath7064]

Thanks 🙏.. that's what i need

[@satishojha6240]

Thanku for recap sir good night 🙏🙏🙏

[@Innozant]

Thanks Satish Ji..Happy Learning

[@vinayakpotadar4093]

Super sir. One question in sumproduct total sum hona sir. But Sum only without blank cell. How to add formula sir please solve the problem sir.

[@situsahoo2482]

I love sum product way.👍👍👍💥🎈 cracking .

[@Innozant]

Thanks Sahoo ji

[@anooparora2515]

Thanks Sir!

[@mohammadhusainvasaya4886]

Awesome Trick…

[@tameshwerkoushal8432]

Thank you so much sir

[@Innozant]

Thanks Koushal Sahab

[@mayankbhatt1790]

Amazing concept 👌👌 and nyc vedio
In place of equal to (=) sign we can also use @ only for the function it automatically changes into equal to sign

[@Innozant]

Yes you are right Mr. Bhatt

[@mayankbhatt1790]

@@Innozant thank you sir and I was comment on ur video 3d sum that we can use wildcard (?) To sum make a video on that all were know about wildcard

[@Innozant]

👍👍

[@puransingh-sx2tk]

Thank you dil se ❤️ Innozant

[@Innozant]

Thanks Puran ji

[@tejpalsain1507]

Super sir.

[@Innozant]

Thanks Tejplal Ji

[@arjuntuteja5955]

Jaadu tha ye toh sir...😃

[@Innozant]

Thanks Arjun

[@kishorpanara4191]

Thanks sir

[@Innozant]

Thanks Kishor

[@rajeshghai1494]

Sir, please make a video on the SUBTOTAL formula's option no. of 7 (STDEV.S),8 (STDEV.P),10 (VAR.S), 11 (VAR.P). Thank Sir.

[@Innozant]

STDEV and other statistical function we are going to introduce soon in excel maharaj

[@bhoopendraraghav9781]

Super se ooper...

[@Innozant]

Thanks Bhoopendrra

[@MIS_PRODUCTION_AAA]

If data are in columns then??

[@shivaprasanna2304]

how to calculate excluding hidden column in excel

[@MuhammadIqbal214G.B]

Sir how to sum alternate columns

[@avinayakchoudhary4172]

Sir please start power query class

[@Innozant]

sure...soon dear

[@amitapattanaik1071]

Lovely

[@Innozant]

Thanks Salil

[@puneetp5967]

Sir
I don't have solution in cell value sum in multiple value like (i.e. date 09/02 - Value 420000/-
10/02 - 420000/-
11/04 - 410000/- ) in single cell
pls resolve sir

[@alsahek]

nice
Thank you
I under stand you but I am not speak urdu language

[@sandeepchavan455]

If sum are same then its work

[@dileepmathulkar6516]

One like (👍) for formula and another 2 likes (👍👍) for script since 4:28 to 4:55.

[@Innozant]

Thanks Dileep Ji for such a valuable appreciation .

[@sitaramkohli9549]

Sir aapne Aggregate ,switch jaise function introduce nhi kiye agar koi aur important functiona h to introduce kijiye sir

[@Innozant]

Aggregate aur Switch aur bhi new functions office 365 Playlist video series me Introduce karenge dear

[@TVSCDN]

The sum of the digits in the 3 rows is 394 ... Not 294😮

[@coolag74]

👍👍👍

[@Innozant]

❤❤🙏🙏

[@gauravbhatia7987]

🙏🙏🙏

[@ashishsharma2127]

Sir please provide contect no. For learn advance formulas in googal sheets

[@techera3563]

SIR AAP YE DATA DISCRIPTION ME V DEDIA KRO TAKI HN PRACTICE KR SKE😐

[@Innozant]

Dear aap check kren description usme already link diya hua hai ..download kren practice file

[@GaganDeep-rx5zx]

😇

[@Innozant]

Thanks Gagan ji

[@gauravbhatia7987]

Sir job nhi mil rahi amritsar mein find kar bhi raha hu but nhi hai jobs sir

[@Innozant]

Aaiye Delhi Ncr..dear

[@aqeelahmadengr3]

Today short video

[@NareshPatel10102001]

Email kya hai apka

[@Innozant]

[e-mail]

[@aslkha3788]

Boring

[@Innozant]

Are Guruji..Chama chahte hain aapko Bore Kiya. Dil ki gehraiyon se khed prakat krte hain😃🙏

[@amitapattanaik1071]

Itana acha toh explain kar rahe Hain, kyon bore lagata hai Bhai, padhai main dhyan do,

[@mohitchauhan7808]

👍👍👍👍

[@Innozant]

Thanks Mohit ji