Average

bbloch18

I have a column " Resolved on Request Date" with a "Yes" or "No"

How can I get a average number of yes replies and an average number of no replies.

I want to be able to create a Dashboard on the information.

THanks,

Mike Wilday

Try the following formulas to calculate the average of Yeses 

=COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "Yes") / COUNT([Resolved on Request Date]:[Resolved on Request Date])

Try the following to average the No's

=COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "No") / COUNT([Resolved on Request Date]:[Resolved on Request Date])