3 Replies Latest reply on Jun 9, 2018 10:42 AM by kausalya durgale

    Sum for unique column id's

    kausalya durgale

      Hi -  I am trying to get a column which will give me the sum of "passed" and "failed" values against each "Test subject" column. Where in my status are not specifically a columns, I have status columns which has status like pass, fail, not run etc. I have attached base excel for reference. in tab 3 "status" columns is in column "D". for ex: if my test subject is FX interface reconciliation then i would need the new column to give me the sum of pass+fail status from tab 3 and the answer should be (0) as the values are null.