My sheet has 4 rows of data and a total row that is supposed to average the results over a week. example:
week1 100
week2 125
week3 140
week4 98
Total =Average(A1:a4)
Problem is if week 2,3 and 4 are empty or my user unknowingly enters a zero the average is incorrect. What I actually want to do is say if week1 is not empty or greater than 0 the average = week1. If week1 and week2 are not empty or greater than 0 then average week1 and week2. Is this possible?
week1 100
week2 125
week3 140
week4 98
Total =Average(A1:a4)
Problem is if week 2,3 and 4 are empty or my user unknowingly enters a zero the average is incorrect. What I actually want to do is say if week1 is not empty or greater than 0 the average = week1. If week1 and week2 are not empty or greater than 0 then average week1 and week2. Is this possible?