AVERAGEIFS Function Excel | Single or Multiple Criteria | AVERAGEIFS Between Two Dates

[@brendavanschie9839]

Good Afternoon. Your videos have nice practical and applicable topics! Can you advise on the formula / process for this problem. I am trying do create a sheet to track accepted quotes for a project. ie. if I receive a quotation for a product, and add the details to one column in my spreadsheet, I input the quote total in another column. In another column I have a drop down list with options 'accepted / rejected / pending'. Only when accepted is chosen will he amount reflect in the total column. Thanks, Brenda

[@excel_along_the_way]

For MS 365 can't you spill the results by selecting all the criteria values?

[@dudeeshs]

Hello, I have to compare two separate sheets for reconciliation. (Invoice number & amount) in sheet 1 vs (Invoice number & amount) in sheet 2 Do you know any formulas for that?