I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate:
=COUNTIF ((RefSheet1Range1)="Windows Server" AND (RefSheet1Range2){Status}="Completed")
This would return a count of the number of Windows Servers that have been completed
Range 1 would ref {Operating System}
Range 2 would ref {Status}
I haven't been able to find a reference in help or community.
Thanks in advance