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
Could you please share your data?
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
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
Is there anything else I can help you with this query?
User 29/06/2018 - 08:06
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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc