I'm working on Excel 2003.
I have a table.

`Date - Column X - Column Y - Column Z - Age`

When the date in the date column equals cell A1, I want to calculate the AVERAGE for the numbers in the age column.
There are many records; I tried using INDEX and MATCH but was unsuccessful. Only the first matching record is left for me.

Nov 13, 2022 in Others 401 views

## 1 answer to this question.

Try:

```=AVERAGE(IF(X:X=A1,Z:Z))
```

With Ctrl+Shift+Enter.

• 63,720 points

## Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

## Excel Function to Exclude rows based on certain values

One method is to combine the FILTER() ...READ MORE

## Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

## In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS(\$H\$3:H3)<=\$I\$1,INDEX(Personnel! ...READ MORE

## In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE