@bestlearnings: Learn 3 data summation techniques using sum, sumif and sumifs - beginner to advanced #excel #EduTok #learnontiktokcontest #todayilearned #fyp
Skip SUMIF. SUMIFS can do single criteria and since it has a different structure as SUMIF it’s better to only use SUMIFS for your muscle memory and you have the ability to easily add more criteria later!
2026-07-22 03:22:25
1
Tyjcon :
Would it not be easier to just filter out what you don’t need for instance you want east filter for east use sum to get your figures?
2026-06-13 01:02:22
4
Zky Vengeance :
pivot table will do all that. true. but learning some new formula will do good as well
2026-06-29 10:24:33
15
Blessings :
enjoyed learning
2026-07-05 17:49:30
3
Malcolm Ajagbe :
I don't think there is anything excel can't do
2026-06-11 09:43:19
2
srkiaaa :
Subtotal function with activated filters in row 6 do wonderful job easier and faster
2026-06-09 20:52:55
4
Mussa Protas :
Scientific computing techniques have no specific fields /subfields or overall sectors or subsectors of the digital economy
2026-07-04 19:30:30
0
Data Expert E.I.JHN :
lol…. Excel and parenthesis SQL cool 😎 lol
2026-07-04 13:20:11
0
George Chewe :
why you are not locking is beyond me
2026-07-08 12:35:53
0
Ofuji |DataAnalyst in Progress :
that's nice
2026-07-08 22:43:06
0
Farooq Shahzad :
So like sql but toned down 🤔
2026-06-19 15:46:24
1
RayZ :
thank for this
2026-06-11 16:08:17
0
God knows what next :
hi sir
2026-07-19 19:18:44
0
Ngai He Hakka Nhin :
Let's take Sales as example.
The boss wanted to know the sum of successful sales vs unsuccessful sales per month, put into a tube graphic with 2 parts, the green part represents successful sales, the grey part represents unsuccessful sales.
Which sum function wold be best used for this situation ?
2026-06-11 08:57:00
1
Convallis :
thx
2026-06-21 16:15:40
0
«£ECMxMANSA» :
thank you sir
2026-06-22 20:56:41
0
claires032 :
lykeee
2026-08-08 04:16:14
0
Saumos :
adding in the filter into the formula makes my brain hurt.
2026-07-03 11:59:14
0
Samantha Sproul :
Or a pivot table?????
2026-06-29 19:26:21
0
Sadrick Jubilee :
thank you that helps 🙏
2026-06-23 16:32:07
0
datadrivenvish :
Excel is goat
2026-06-14 00:14:47
0
To see more videos from user @bestlearnings, please go to the Tikwm
homepage.