2 Comments

    • =SUM(SUMIFS(C:C,F:F,{“Criteria1″,”Criteria2″},S:S,”Criteria3”))

      Replace C with the column you want to get your count from (your sum range)
      Replace F with your first criteria range, followed by criteria
      Replace S with your second criteria range, followed by criteria

      Note placing criteria 1 & 2 in the {} acts like an OR statement.

      This formula sums column C where column S=Criteria3 AND column F= Criteria1 OR Criteria2.

      View Comment

Leave a Reply