I want to count how many times a certain word appears in a column if it's in the same row --- if another word appears in another column.
I am working with 2 sheets.
I want to get the information in the 1st sheet, while looking into the 2nd sheet.
Column G has either deployed or pending
Column J has Department names
I want to get the number of times it says Deployed if it falls in the same row of a particular department name
I tried Various Countifs, but unsuccessful.
One countifs I tried was:
=COUNTIFS('Full List'!G:G, "deployed",'Full List'!J:J,"Operations")
Full List is the sheet name Operations is the department name
Any help will be appreciated