Get Count Based on Header and Lookup Value

Hi,

I am trying to look up count of feedback received by Matching headers in Result Sheet with Data sheet. Also, trying to lookup and get the count of value. For Example

In the sheet attached, I am trying to match Objectives Header in Dashboard with Objectives Header in AQGH & AQWCH Feedback sheet. And on the left I have the rating. I want to get count of "Strongly Disagree" in Column G3 from column N in AQGH & AQWCH Feedback sheet matching with the headers.

Help is appreciated on this. Thank You!

Originally Posted by AliGW

You can't do a matrix lookup with COUNTIFS. Try:

=SUMPRODUCT(('AQGH & AQWCH Feedback'!$N$2:$N$26=[@Rating])*('AQGH & AQWCH Feedback'!$N$1:$T$1=Table3[[#Headers],[Objectives]]))

Thank you that worked!