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

Also read: Arrows keys are not working in Microsoft Excel. text argument is used to specify the string that contains the characters that need to be found. [num_chars] specifies the number of ...

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