# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to figure out how to calculate average reaction time for correct responses. I currently have one collum with either a 'C' or 'E' for correct or error and another collum with reaction time.
Solved by Z. Q. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/06/2018 - 07:58
Hi…Welcome to Got It Pro
Excelchat Expert 29/06/2018 - 07:59
User 29/06/2018 - 08:00
Unfortunately,​ I can't share it because it has confidential information about research participants on it.
Excelchat Expert 29/06/2018 - 08:00
You can present a sample in this preview sheet and I can illustrate the formula, if that works.
User 29/06/2018 - 08:02
Like that?
Excelchat Expert 29/06/2018 - 08:02
ok...so you would like to average of C and E, is that right?
User 29/06/2018 - 08:03
Yes
Excelchat Expert 29/06/2018 - 08:03
Sure..let me work out the formula for you.
Excelchat Expert 29/06/2018 - 08:05
There you go....
Excelchat Expert 29/06/2018 - 08:05
Formula is in E2 and E3
Excelchat Expert 29/06/2018 - 08:05
Its an Averageif formula.
User 29/06/2018 - 08:06
Awesome! Thank you!
Excelchat Expert 29/06/2018 - 08:06
Syntax is = Averageif(CriteriaRange,Criteria,Average range)
Excelchat Expert 29/06/2018 - 08:06
User 29/06/2018 - 08:06
Nope
Excelchat Expert 29/06/2018 - 08:06
Please do give me few feedback comments for my service at the exit of this session.
Excelchat Expert 29/06/2018 - 08:06
Thanks for your time. Please do come back for any new question. You can now end this session. Have a great weekend!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.