【Excel】OR条件でSUMIFS（必ずSUMIFS使うとは言っていない）【YT0088】

This explains how to perform summation based on multiple conditions, similar to SUMIFS, using OR conditions instead of AND conditions. Yuichi Chiba ━━━━━━━━━━━━━━━━━━━━━ 🎦 Playlist ━━━━━━━━━━━━━━━━━━━━━    • Excel関数と数式のテクニック   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Membership ━━━━━━━━━━━━━━━━━━━━━ You can check member-only benefits via the link below.    / @exceldokatach   ━━━━━━━━━━━━━━━━━━━━━ ✅️ X (formerly Twitter) ━━━━━━━━━━━━━━━━━━━━━ We tweet about video updates and other things.   / chiba_u1   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Online Courses ━━━━━━━━━━━━━━━━━━━━━ 🔗Excel Power Queries [Beginner Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Power Queries [Elementary Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Power Pivot Tables [Elementary Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Pivot Tables [Beginner Level] https://uyrDOv.short.gy/sutoaka-class... 🔗 Online Course List https://uyrDOv.short.gy/sutoaka-teacher ━━━━━━━━━━━━━━━━━━━━━ ✅️ Article Posting ━━━━━━━━━━━━━━━━━━━━━ I post articles about Excel functions, Power Queries, Power Pivot, and DAX. https://note.com/excel_dokata ━━━━━━━━━━━━━━━━━━━━━ ✅️ Contact Information for Business Inquiries ━━━━━━━━━━━━━━━━━━━━━ For inquiries regarding outsourcing, contract work, instructor requests, consulting, private lessons, etc., please contact me here. [email protected] ━━━━━━━━━━━━━━━━━━━━━ ✅️ Excel Version ━━━━━━━━━━━━━━━━━━━━━ The Excel used in this video is Microsoft 365 Personal (Office Insider Beta, the latest version at the time of video release). ━━━━━━━━━━━━━━━━━━━━━ ✅️ Sample File ━━━━━━━━━━━━━━━━━━━━━ 【Membership (Serious Union Members and above) Only】    • Post   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Timestamps ━━━━━━━━━━━━━━━━━━━━━ [ 00:00 ] Introduction [ 00:48 ] When the condition column is 1 column [ 02:51 ] OR condition when the condition column is 1 column [ 08:57 ] AND condition when the condition column is 2 columns [ 09:59 ] OR condition (FILTER and SUM) when the condition column has 2 columns [13:07] OR condition (SUMIFS) when the condition column has 2 columns ━━━━━━━━━━━━━━━━━━━━━ ✅️ Online Individual Consultation ━━━━━━━━━━━━━━━━━━━━━ You can consult about Excel using Zoom. https://uyrDOv.short.gy/sutoaka-reque...