Formula help for averaging data in 1 column based on criteria from 2 other columns
I need help with a formula that will average the total in 1 column based on 3 criteria of another column and 1 criteria of another column.
To phrase better, I have a column of dollar amounts that I need to average based upon the sum of all values in that column. BUT, the values to sum are based upon 3 status values of another column and yet an additional column dependent upon field that have no blank values.
- Column 1 just has dollar values the will be used to provide an overall average dollar amount
- Column 2 has status values such as complete, active, in review, etc.
- Column 3 has dollar values but must not be blank
Help Article Resources
Check out the Formula Handbook template!