Average If Not Blank

Kaleb

Smartsheet Community:

My Results are Still 0 when they Should Be Blank. I am Not Sure what I am doing wrong with This Formula.

Current Formula:

=AVERAGEIF(SPI@row:CPI@row, <>"", SPI@row:CPI@row)

Desired Results:

If SPI & CPI are Not Blank Provide an Average. If They are Blank Then The Results Should Be Blank / Empty.

Thanks

Jeff Reisman

@Kaleb Try this:

=IF(AVERAGEIF(SPI@row:CPI@row, <>"", SPI@row:CPI@row) = 0, "", AVERAGEIF(SPI@row:CPI@row, <>"", SPI@row:CPI@row))

Jeff Reisman

@Kaleb Try this:

=IF(AVERAGEIF(SPI@row:CPI@row, <>"", SPI@row:CPI@row) = 0, "", AVERAGEIF(SPI@row:CPI@row, <>"", SPI@row:CPI@row))

Kaleb

Excellent, Thanks @Jeff Reisman