I have a spreadsheet with data in this format:
User | Group | ParentGroup | ID joe | US fed grp | fed | 123 bill | dev | IT | 234 jim | UK fed grp | fed | 345
I need a formula that would search the Group and ParentGroup columns across the entire sheet and give the total rows count of rows containing 'fed'
In the example above, the formula would return 2 (not 4, which is the number of times 'fed' appears in the entire sheet). 2 is the number of rows that 'fed' appears on.
I am trying
=COUNTIF(1:4, "*" & "fed" & "*")
but it's returning 4 (I want 2)