Hello,
The following formula works for counting data in 'Survey Data'!A:A
=COUNTIFS('Survey Data'!A:A,Appraisal!A3,'Survey Data'!K:K,">="&B1,'Survey Data'!K:K,"<="&C1)
How can I adjust to also count (sum) matching data Columns B & C also.
I tried this first but it didn't work:
=COUNTIFS('Survey Data'!A:C,Appraisal!A3,'Survey Data'!K:K,">="&B1,'Survey Data'!K:K,"<="&C1)
I appreciate any help.
Thank you,
Bookmarks