Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or ...

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 ...