Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to ...

I'll use the COUNTIF function with a wildcard to tell Excel to count how many cells in row 1 contain the word "Week" followed by a number: =COUNTIF(1:1,"Week*") I can now use this information to ...