Excel Magic Trick 854: COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column
Loading...
Loading...
2,118
Loading...
Uploader Comments (ExcelIsFun)
Video Responses
This video is a response to Excell help needed - how to
see all
All Comments (14)
-
Thanks Mike. Reverting back to basics? :)
-
Thank you, thank you, and thank you again!!!
-
urpanita , I am glad that you liked it!
-
sperdoch, you are welcome!
Loading...
1:14
Excel Magic Trick 855: Change Military Time To Non-Military Time (Time Number Formatting)by ExcelIsFun838 views- 3:21
Excel Magic Trick 804: Chart Double Horizontal Axis Labels & VLOOKUP to Assign Sales Categoryby ExcelIsFun2,992 views
- 3:15
Excel Magic Trick 857: SUMIF Function with Sheet References: Summarize Data From Different Sheetby ExcelIsFun1,944 views
- 6:36
Excel Magic Trick 853: Lookup Number That Occurs Least Frequently (2 Methods)by ExcelIsFun988 views
- 5:44
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...by ExcelIsFun426,356 views
- 10:03
Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!??by ExcelIsFun2,165 views
- 4:37
Excel Magic Trick 835: Drill Through Conditional Formatting Across Sheets Using Format Painterby ExcelIsFun1,887 views
- 13:37
Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)by ExcelIsFun2,601 views
- 7:17
Excel Magic Trick 848: Create List of Dates For Month With Formulaby ExcelIsFun3,803 views
- 20:24
Excel Magic Trick 866: Four Lookup Values In VLOOKUP Formula? 6 Examplesby ExcelIsFun2,277 views
- 5:38
Excel 2010 Magic Trick 815: Case Sensitive Lookup using EXACT and LOOKUP functionsby ExcelIsFun1,123 views
- 7:18
Microsoft Excel 2010 Expert Level 1 Introductionby 599CD13,168 views
- 2:23
Excel COUNTIFS Count With Multiple Criteriaby contextures482 views
- 5:27
Excel Magic Trick 803: COUNTIF Function Criteria & Comparative Operator Trouble & ASCII Charactersby ExcelIsFun2,816 views
- 8:31
Excel 2010 Magic Trick 816: Compare Tables & Extract Records In Table 2 That Are Not In Table 1by ExcelIsFun1,383 views
- 4:28
SUMIF and COUNTIF functions in Excel V2by AuditExcel9,880 views
- 3:41
Excel Magic Trick 837: Lookup Multiplying with SUMIF & PRODUCT Experimental Outcome Probabilityby ExcelIsFun1,102 views
- 1:12
Excel Count Ifby SpringboardHackney1,675 views
- 7:17
Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fastby ExcelIsFun28,258 views
- 1:38
Excel Magic Trick 827: Alt + Tab To Switch Between Open Windows (YouTube Video & Excel Workbook)by ExcelIsFun1,013 views
great! I wonder if you could kindly answer my question?
Can I use if and SUM same way ?
I'm working on an overview page for date spread over many sheets.
0selam 4 weeks ago
@0selam , yes you could use SUMIF function. see this video:
Excel Magic Trick #203: SUMIF function formula 21 Examples
or
Highline Excel Class 09: SUMIF Function Formula 3 Examples
ExcelIsFun 4 weeks ago
@ExcelIsFun Thanks a lot! much Appreciated!
0selam 3 weeks ago
@0selam , you are welcome!
ExcelIsFun 3 weeks ago
krn14242, this was answering a question. But yes, the demand for Basic Videos is always very high! Higher than for advanced videos!
ExcelIsFun 1 month ago
Cosme422 , I am glad that it worked and solved your problem!
ExcelIsFun 1 month ago