In that case we can use the formula “Sumif” Let’s take an example to understand it, If I am having salesman names in column “A” and sales value of that salesman in column “B” then i can use this formula to get the total sales of each salesman.

$domainController = ([System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()).DomainControllers[0].NameWrite-Host “Domain Controller Hostname: $domainController”

Power shell scripts are groups of commands which we can use to get the desired output.