79766743

Date: 2025-09-16 22:49:55
Score: 2.5
Natty:
Report link

For cell F6, I found this formula to work:

=SUM(COUNTIFS(C2:C12,FILTER(C2:C12,B2:B12=2,""),A2:A12,"Diagnosis"))

Using the named ranges described above:

=SUM(COUNTIFS(Names,FILTER(Names,Value=2,""),Criteria,"Diagnosis"))

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Icron