text: Q:
  
  Counting the Amount with Multiplication Condition
  
  I have an Excel List That Looks Like This:
  
  And i need to Count the Amount of Rows that have the Value Finished in Row C. But if T Value in Column B Contains a Semikolon it hase to Count double, if it Contains 2 Semikolons it hase to count 3 and so on...
  Her is a Picture to show how the Counting should work.
  
  I will not be able to Add Another Column to the Sheet, so i'm Locking for a Matrix Fomula or something like this.
  Till now i tried it with the Countif and Countifs Formula but that didn't work.
  Can someone give me a hint how to do thsi or waht Fomula would be the best to use?
  
  A:
  
  For your "Finished" total, use this formula (adjust ranges as necessary to fit your actual data):
  =SUMPRODUCT((LEN($B$5:$B$28)-LEN(SUBSTITUTE($B$5:$B$28,";",""))+1)*($C$5:$C$28="Finished"))
  
  For your "Pending" total, if it needs the same treatment, use this formula:
  =SUMPRODUCT((LEN($B$5:$B$28)-LEN(SUBSTITUTE($B$5:$B$28,";",""))+1)*($C$5:$C$28="Pending"))
  
  