7 ways to using SUM SUMIF and SUMIFS formula in ms excel | Ep 01
Hello my friend today I going to show you 7 ways to use SUM, 5 ways to using SUMIF and SUMIFS formula in ms excel. I know you maybe can using excel and know some of this sum formula and this video is will show you more how to using this formula. I already show you one by one, If you not understand or need more video please drop comment below, I will make the video for you. If you prefer this video please like and subscribe for more video. Thank you for watching. Please see the formula in video below : - 7 ways for sum function: ○ =SUM(G5,G6,G7,G8,G9) ○ =SUM(G5:G9) ○ =SUM(G5:G7,G8:G9) ○ =SUM(G5,G6:G9) ○ =SUM(G5:G8,G9) ○ =SUM(G5:G6,G8:G9) ○ =G5+G6+G7+G8+G9 - 5 ways for sumif function: ○ =SUMIF(F5:F9,"B",G5:G9) ○ =SUMIF(F5:F9,"??A",G5:G9) ○ =SUMIF(G5:G9,4,G5:G9) ○ =SUMIF(G5:G9,"?2",G5:G9) ○ =SUMIF(F5:F9,"A",G5:G9)+SUMIF(F5:F9,"B",G5:G9) - sumifs function: ○ =SUMIFS(G5:G9,E5:E9,"b",F5:F9,"A") For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ Check out my previous video : Beginners | How to create quiz online in google form Ep1 : https://www.youtube.com/watch?v=gJ2O4... - How to connect youtube with tik tok : https://www.youtube.com/watch?v=5GR8y... - How to rename labels in blogger : https://www.youtube.com/watch?v=IBbaR... - How to invite participants join meeting in zoom : https://www.youtube.com/watch?v=XD_Ob... - How to find video recording in zoom meeting : https://www.youtube.com/watch?v=RKbSJ... - How to disable zoom mirror video : https://www.youtube.com/watch?v=M-i0v... - How set auto join in zoom meeting : https://www.youtube.com/watch?v=jOiWk... - How to block chat from player not friends in ML : https://www.youtube.com/watch?v=NOKbu... - How to download video from youtube without software : https://www.youtube.com/watch?v=0_N-C... - How to login two account in Tik Tok ? : https://www.youtube.com/watch?v=7715I... Check out my popular playlist : - Excel tutorials 2020 : https://www.youtube.com/playlist?list... - Blogger tips and tricks : https://www.youtube.com/playlist?list... - Google Form : https://www.youtube.com/playlist?list... - General Knowledge: https://www.youtube.com/playlist?list... - Technology tips and tricks: https://www.youtube.com/playlist?list... - Game : https://www.youtube.com/playlist?list... Computer tips and tricks : https://www.youtube.com/playlist?list... If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app ... My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week. Thank you for your time, And hope all my video is helpful for you, Have a nice day !