Conditional Sum for Visible Rows ONLY - when SUMIF Fails

  Рет қаралды 1,402

Officeinstructor

Officeinstructor

Күн бұрын

Пікірлер: 17
@IvanCortinas_ES
@IvanCortinas_ES 10 ай бұрын
Magnificent exhibition. The appearance of the SUBTOTAL function is very brilliant. It catches my attention, since it was a function that has long disappeared and with 365 it is taking on some importance. Thank you my friend.
@Officeinstructor
@Officeinstructor 10 ай бұрын
Glad you liked it and thanks for watching
@Luciano_mp
@Luciano_mp 10 ай бұрын
Great solution! Thank you Nabil!
@Officeinstructor
@Officeinstructor 10 ай бұрын
You are welcome!
@nadermounir8228
@nadermounir8228 10 ай бұрын
Brilliant video Nabil. Thank you for this amazing tutorial 👍
@Officeinstructor
@Officeinstructor 10 ай бұрын
Glad you liked it! Thanks for watching
@gandhisunil3
@gandhisunil3 9 ай бұрын
Thanks A ton Nabil.. At one point you said column hidden instead of Row hidden, but we understood from context as row
@Officeinstructor
@Officeinstructor 9 ай бұрын
I am a human being and I make mistakes. Luckily this was just an extremely simple one and it is definitely understood from the context. If it proves anything that will be I am recording live ...
@prashantsureka1
@prashantsureka1 2 ай бұрын
Thanks and great work bro.looking solution for this from many years.
@Officeinstructor
@Officeinstructor Ай бұрын
Always welcome
@Rturnerjr1
@Rturnerjr1 5 ай бұрын
Excellent - thank you for your explanation
@yousrymaarouf2931
@yousrymaarouf2931 10 ай бұрын
Fantastic
@Officeinstructor
@Officeinstructor 10 ай бұрын
Thank you so much 😀
@gandhisunil3
@gandhisunil3 9 ай бұрын
Secondly what is the source of pics like calculator display screen showing visible rows
@Officeinstructor
@Officeinstructor 9 ай бұрын
Google Image with my editing
@alializadeh8195
@alializadeh8195 10 ай бұрын
Thanks Please go for Access ...
@Officeinstructor
@Officeinstructor 10 ай бұрын
Nothing planned for now.
Interactive Sheet Tab Names - Hot Excel Topic
10:21
Officeinstructor
Рет қаралды 1,7 М.
6 Confusing Functions Having "ROW" in Their Names - SIMPLIFIED
25:33
Officeinstructor
Рет қаралды 3 М.
Chain Game Strong ⛓️
00:21
Anwar Jibawi
Рет қаралды 41 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 124 М.
List To Matrix - Pivot Tables FAIL but Functions Can DO It
8:45
Officeinstructor
Рет қаралды 2,7 М.
5 Conditional Formatting Hacks That Will Blow Your Mind
11:16
Mike’s F9 Finance
Рет қаралды 11 М.
Why Pro Excel Users Love SUMPRODUCT!
8:08
MyOnlineTrainingHub
Рет қаралды 63 М.
How to use the TEXTSPLIT Function - A Complete Guide
16:30
Officeinstructor
Рет қаралды 2 М.
Better than XLOOKUP? Try SUPERXLOOKUP!
11:39
Excel Off The Grid
Рет қаралды 54 М.
DOUBLEXLOOKUP... the Excel function you've been waiting for!
12:29
Excel Off The Grid
Рет қаралды 32 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 273 М.