Can we use a Sum or Avg formula to rows/columns which has a IF condition.
I was trying to prepare a report in which I used a IF conditions to get the expected value based on my clients response from the forms. Now, I want to do a SUM or AVG with the rows that I have the conditions. I get #DIVIDE BY ZERO ERROR when AVG is applied & I get the final value as 0 when I apply the Sum formula.
Help Article Resources
Check out the Formula Handbook template!