Query to find count and sum

praveen raju Slightly delayed (found my way to the tech community via Ignite) but if only for any future searches.

You'll want to use Group-Object to collect the values by category (You have an extra period on the first 2 entries which would skew the results).  Assuming you had the data as a csv and imported it to $data you can use the below

$data | Group-Object Category | ForEach-Object {
  [pscustomobject]@{
    Category = $_.name
    'Sum(savings)' = ($_.group.'annual savings' | Measure-object -sum).sum
    'Count(Category)' = $_.count
  }
}