Sum and divide
Hello Guys
This is a quick question but maybe with an complicated answer
Im making a very simple survey , this documents has a scale from 1 to 5
There's a way when i type there 0 "zero" or N/A (no apply) , the formula can be set automatically to calculate the resuelt without editing the dividend
A quick example will be:
Question 1: 4
Question 2: 3
Question 3: 1
Total = 8 divide / 3 = 2.666
But i want that calculate automatically the result without editing the formula
Example
Question 1: 4
Question2: N/A
Question 3: 2
Total= 6/2 = 3
use the AVERAGE formula
use the AVERAGE formula
Hi Nick. Thanks for the quick
Hi Nick. Thanks for the quick reply.
I try to use that function but is not working. I mean, it calculates but not how i want. Maybe i don't know how to use it.
What i need is when i put zero in one of those cell, it can automatically divide between the cells i choose an scale.
For example in question 2 if i put zero, average is still divide 3 and it should divide 2.
Sorry if i don't explain me well, English is not my first language.
Conditional AVERAGE formula
Hi,
Try with AVERAGEIFS formula. For example:
= AVERAGEIFS(B1:B3, B1:B3, "<> 0", B1:B3, "<> N/A")
There is also AVERAGEA and AVERAGEIF which you can examine and use when you need. There are many examples in the Excel's Help.
Best regards.
Thank You, both of you
Thank You, both of you guys.
I will make some test, and use the help and look for videos too.
Have a nice day Sir.