Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y

0 votes

I want to show the Time Approved average from the following collection of data. However, I only want to show the Time Approved average when the Approval Type and Approver are both Yellow Type.

If I wanted to, I could use AverageIf() to obtain Cathy's average time authorized, but what if the approval type was Yellow Type? How would I go about obtaining Cathy's average then?

enter image description here

Nov 10 in Others by Kithuzzz
• 20,660 points
30 views

1 answer to this question.

0 votes

Use AVERAGEIFS ...

=AVERAGEIFS(C2:C13,A2:A13,"Yellow Type",B2:B13,"Cathy")

enter image description here

answered Nov 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

How can I get the intersection, union, and subset of arrays in Ruby?

I want to develop many methods for ...READ MORE

Aug 8 in Others by krishna
• 2,820 points
57 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

answered Nov 8 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Control cell value from another cell in Excel

You may accomplish this by using two ...READ MORE

answered Nov 10 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

Why java have transient fields?

Variables may be marked transient to indicate that they ...READ MORE

answered May 28, 2018 in Java by Daisy
• 8,120 points
416 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
38 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP