1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Counting # of occurrences by month and year.

    From Eric Hart@21:1/5 to All on Wed Oct 21 16:55:00 2020
    Hey all
    I'm trying to figure out how to count with multiple criteria.. how many entries each month/year (column B) that have "X" and don't have "X" (column C)
    So for example
    2019 2020
    Oct Nov Dec Jan Feb Mar Apr May
    X 6
    No X 2

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)