How to get data for only a certain amount of columns (specified by an if)

[oseroser]

Dear all,
For an M&A study we are to look up the differences of certain characteristics (abnormal return/alphas/betas) for bot related and unrelated industry-acquisitions. We created already an if function for every company (1 for every column) to see whether the acquisitions was related (=1) or unrelated (=0). How can we easily compare different data between the two different sort of industries? We have about 400-500 different companies, so it is tough to do it manually.
We tried for example to create two different rows, and when it was related for example it gave the mean, and when it was unrelated it was 0. But if we now want to calculate the Var or the StDev, it uses the zeros as well and we get a wrong outcome. Any easier ways to do this?

[CRIMEDOG]

I am not sure what you are asking - but perhaps a Countif or Sumif formula is called for? =iferror(Sumif(A1:A200,B1:B200,"=0"),0)
This would sum all the values in the range where the Related Unrelated column is Unrelated(0). Or Countif would count instead of Sum.