How do you count the items based on Multiple Criteria in Excel (Use of COUNTIFS function)?


Here we explore how to count and visualize the occurrences of unique dates based on different criteria. The formulas in Columns H and I are employed, utilizing the COUNTIFS function to dynamically count occurrences for specific Bands.

Column H Formula (=COUNTIFS($A:$A,$G2,$D:$D,"="&H$1)):

This formula counts the number of occurrences where the Date (Column A) matches the unique date in Column G for a specific Band (Column D) represented by the header in H1.

$A:$A,$G2: Matches the Date in Column A with the unique date in Column G.

$D:$D,"="&H$1: Matches the Band in Column D with the Band represented by the header in H1.

Column I Formula (=COUNTIFS($A:$A,$G2,$D:$D,"="&I$1)):

Similar to the formula in Column H, but it counts occurrences based on the Band represented by the header in I1.

We break down the formulas step by step:

  • COUNTIFS($A:$A,$G2,$D:$D,"="&H$1): Count occurrences based on a unique date in Column G and a specified Band represented by the header in H1.
  • COUNTIFS($A:$A,$G2,$D:$D,"="&I$1): Similar logic, but counting for a Band specified in I1.

These formulas offer a powerful way to analyze and gain insights into your network data, allowing you to tailor your analysis based on specific Bands and corresponding dates.

Video link: https://youtu.be/jiJXl0DRHJQ

Earn money by survey (Trusted and relay able site)