AVERAGEIFS

Shaun Williams

Good afternoon community, i am trying to transfer an excel formular into Smartsheet and i am having issues with the formular due to it being an averageisf formular.

The formular:

=AVERAGEIFS($R:$R,$S:$S,BC5,$D:$D,$BD$3)

The logic:

The calculation is: if both the indicator and the month (as a number) match, then calculate the average value of column R (repair time).

Please can someone support?

Paul Newcome

You would use an AVG/COLLECT combo instead.

=AVG(COLLECT(……………………))

Paul Newcome

You would use an AVG/COLLECT combo instead.

=AVG(COLLECT(……………………))

Shaun Williams

Thank you Paul it worked…you legend!

Paul Newcome

Happy to help. 👍️