Requesting help to pull data in one spreadsheet from one worksheet to another if certain criteria are met.
FY23 PA Grp Funds by Program sheet screenshot where I want the formula and results to populate in cell B3: (if certain criteria are met in screenshot 2):
Criteria to meet from this worksheet entitled Program Funds Total FY22/23 : If there is anything in column A (PA Cohort) I would like it to sum the range under column M (Pitch Funding) and populate the cell B3 in the FY23 PA Grp Funds by Program worksheet:
FY23 PA Grp Funds by Program sheet screenshot where I want the formula and results to populate in cell B3: (if certain criteria are met in screenshot 2):
Criteria to meet from this worksheet entitled Program Funds Total FY22/23 : If there is anything in column A (PA Cohort) I would like it to sum the range under column M (Pitch Funding) and populate the cell B3 in the FY23 PA Grp Funds by Program worksheet: