# Is there a beast mode I can use to add two columns and then get the average?

Options
Member

• Coach
Options

If itβs always just the 2 columns, and you will have nulls. You could do

```(col1+col2)/2
```

David Cunningham

** Did this solve your problem? Accept it as a solution! βοΈ**

• Contributor
Options

Maybe something like:

sum(ifnull(`R-Phone Interview`, 0) + ifnull(`R-Virtual Interview`, 0))/(count(`R-Phone Interview`) + count(`R-Virtual Interview))`

• Coach
Options

As mentioned, it's just (col1+col2)/2. Use coalesce(col1,0) if you have nulls. They will become zero.

** Did this solve your problem? Accept it as a solution! **

• Coach
Options

If itβs always just the 2 columns, and you will have nulls. You could do

```(col1+col2)/2
```

David Cunningham

** Did this solve your problem? Accept it as a solution! βοΈ**

• Contributor
Options

Maybe something like:

sum(ifnull(`R-Phone Interview`, 0) + ifnull(`R-Virtual Interview`, 0))/(count(`R-Phone Interview`) + count(`R-Virtual Interview))`

• Coach
Options

As mentioned, it's just (col1+col2)/2. Use coalesce(col1,0) if you have nulls. They will become zero.

** Did this solve your problem? Accept it as a solution! **

• Member
Options

Thank you all!