Excel How To Count and Sum Negative Numbers

Опубликовано: 22 Ноябрь 2023
на канале: Excel University

14,280

106

File Download: https://www.excel-university.com/yt_m...

This short videos demonstrates how to count negative cells with the COUNTIF function, how to sum negative cells with the SUMIF function, and how to identify negative transactions with Conditional Formatting.

🚀 Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro 👉 excel-university.com/challenge⚡️🕒 Say goodbye to late nights and spreadsheet struggles!

Subscribe here 👉 https://www.youtube.com/c/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

Chapters in this video:
00:00 - Introduction
00:11 - COUNTIF
01:13 - SUMIF
01:55 - Conditional Formatting

Also, check out these videos with time saving Excel Hacks:

Excel PivotTables for Beginners (2023)    • Excel PivotTables for Beginners (2024)

Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series

Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series

Watch Dynamic Arrays playlist here    • Dynamic Arrays Series

Watch Treasure Maps playlist here    • Treasure Maps Series

Watch Slow to Fast playlist here    • Slow to Fast Series