Hello All,

First time in this forum and new to VBA, so I appreciate any help I can get.

Trying to create code for a COUNTIFS function to return values from another worksheet.
The two worksheets being used are:
  1. Central Summary: where my value is to be returned and that has the "text" i want to search in the 2nd worksheet
  2. Central Data: the data sheet i want referenced and counted.


I want the script to return value into Cell C16 of my "Central Summary" worksheet;

I need the code to search column M in my "Central Data" worksheet for text in Cell A23 from the "Central Summary" worksheet, then using that criteria, search the "Central Data" worksheet again for the words "On Hold" in Column A and return the sum of those occurrences.

The current working formula is below

=COUNTIFS('Central Data'!M:M,'Central Summary'!A23,'Central Data'!A:A,"On Hold")

Thank you in advance for all the help.
A.