I would like to Average B3:U3 if there is any data stored there and return the average in X3. I keep getting the "DIV/0" if no data is stored. how do i Average B3:U3 when data is present, but return 0 if there is no data. Thanks jim