平均と検索を紹介したと思います。 実はそれ一つの関数でできちゃうんです。(数字のみですが、、、) それが今回紹介する AVERAGEIF関数です。 パッと聞いただけだと、平均を返す関数なので検索？？と思われますが使い方によってはかなり便利で重宝します。

Excel's AVERAGEIF and AVERAGEIF functions let you find the average of a set of data. However, where they differ from the more straightforward AVERAGE function is in their ability to include or ...

The AVERAGEIF function in Excel is a tool that can help you find the average value of a range of cells that meet specific criteria. It’s a useful feature for spreadsheet users working with large sets ...

expression A variable that represents a WorksheetFunction object. Cells in a range that contain True or False are ignored. If a cell in a range or average_range is an ...