How to use SUMIF and COUNTIF in Excel
In this video, I show you how to use the COUNTIF and SUMIF functions to automate your reporting.
Whether you need to count how many times a salesperson appears in a list or sum up the total revenue for a specific region, these two formulas are the fastest way to get answers without using Pivot Tables.
Formulas used in this video:
COUNTIF (Frequency): =COUNTIF(range, criteria) Example: =COUNTIF(B:B, "Steve")
SUMIF (Totals): =SUMIF(range, criteria, sum_range) Example: =SUMIF(D:D, "Laptop", E:E)
Logical Operators (Greater Than): Example: =COUNTIF(E:E, "1000")
add greater than sign in front of 1000
Stuff I use | Amazon Affiliate Links
Keyboard-Corsair K70: https://amzn.to/3LQDhay
Mouse-Logitech G502: https://amzn.to/3NMPNbE
Headset-HypercloudX: https://amzn.to/49zJnp7
Microphone-Audio Technica AT2020: https://amzn.to/4bAjoyT
Microphone Stand-Neewer Mic Arm: https://amzn.to/4pEBuDn
Audio Interface-M-Track Duo: https://amzn.to/4sHfLxg
Disclosure: As an Amazon Associate, I earn from qualifying purchases. These links help support the channel at no extra cost to you!
#Excel #ExcelTips #DataAnalysis