# Help to calculate the average in different places with the formula = averageif more than 2

1. ## Help to calculate the average in different places with the formula = averageif more than 2

I have tried to find this as possible, but this has always been affected, the result is 21.25. It's important to make savings for game vouchers and buy high spec laptops. Can anyone help me for the following criteria:
- Zero didn't see
- Average does not affect different cells eg: a1: a2; b1: b2
- Averages will not affect separate figures, for example:
a1 = 20
a2 = 55
b1 = 10
b2 = 0
Capture.PNG
average = 28.33 (average for a1: a2 and b1: b2, 0 doesn't see 0)
I am a student.  Register To Reply

2. ## Re: Help to calculate the average in different places with the formula = averageif more th

Hello and welcome. In your example, if b2 actually has 0 in then =AVERAGE(A1:B2) gives 21.25. If b2 is blank, average gives 28.33 which you don't want.
To get an average whether any of the cells are blank or not, use =SUM(A1:B2)/(COUNTBLANK(A1:B2)+COUNTA(A1:B2)). This will give 21.25.  Register To Reply

3. ## Re: Help to calculate the average in different places with the formula = averageif more th

Or use the AVERAGEIF function which is certainly available in your version (if I understood the query which is not very clear)  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 