Forum Discussion
Need help counting occurrences of text only when adjacent cell has numbers
Need help with formula to count the number of times "ABC" occurs if the adjacent cell has numbers in it. (i.e. not counting occurrence when adjacent cell is blank). The below spreadsheet show total a...
=SUM(N(IF(ISNUMBER(B1:B9),A1:A9="ABC")))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thank you!