User Posts: Osman Goni Ridwan
0
How to Flip Data in Excel from Bottom to Top (4 Quick Methods)
0

If you are searching for the solution or some special tricks to flip data in Excel from bottom to top then you have landed in the right place. There are some ...

0
How to Make a Table in Excel with Lines (with Easy Steps)
0

If you are searching for the solution or some special tricks to make a table in Excel with lines then you have landed in the right place. There are some quick ...

0
How to Create Multiple Sheets in Excel at Once (3 Quick Ways)
0

If you are searching for the solution or some special tricks to create multiple sheets in Excel at once then you have landed in the right place. Sometimes, you ...

0
How to Zoom Out on Excel Online (4 Quick Ways)
0

If you are searching for the solution or some special tricks to zoom out on Excel online version then you have landed in the right place. There are some easy ...

0
How to Calculate T Score in Excel (4 Easy Ways)
0

If you are searching for the solution or some special tricks to calculate the T score in Excel then you have landed in the right place. There are 4 quick ways ...

0
How to Repeat Cell Values in Excel (6 Quick Methods)
0

If you are searching for the solution or some special tricks to repeat cell values in Excel then you have landed in the right place. There are 6 or more ways ...

0
Cash Flow Statement Format in Excel for Construction Company
0

If you are searching for the solution or some special tricks to create a Cash Flow Statement format in Excel for a construction company then you have landed in ...

0
How to Prepare Financial Statements in Excel (with Easy Steps)
0

If you are searching for the solution or some special tricks to prepare financial statements in Excel then you have landed in the right place. You may need ...

0
Currency with 2 Decimal Places in Excel (with Quick Steps)
0

If you are searching for the solution or some special tricks to apply Currency format with 2 decimal places in Excel then you have landed in the right place. ...

0
How to Hide Extra Cells in Excel (with Quick Steps)
0

If you are searching for the solution or some special tricks to hide extra cells in Excel then you have landed in the right place. Often you want to focus only ...

0
How to Unhide Columns in Excel All at Once (4 Quick Ways)
0

If you are searching for the solution or some special tricks to unhide columns in Excel all at once then you have landed in the right place. There are 4 quick ...

0
How to Increase Excel Column Limit (2 Possible Ways)
0

If you are searching for the solution or some special tricks to increase the Excel column limit then you have landed in the right place. This article will show ...

0
How to Add Comma in Excel Between Names (4 Suitable Ways)
0

If you are searching for the solution or some special tricks to how to add comma in Excel between names then you have landed in the right place. There are some ...

0
How to Remove Zeros in Front of a Number in Excel (6 Easy Ways)
0

If you are searching for the solution or some special tricks to remove zeros in front of a number in Excel then you have landed in the right place. There are ...

0
How to Grey Out Unused Cells in Excel (3 Quick Methods)
0

If you are searching for the solution or some special tricks to grey out unused cells in Excel then you have landed in the right place. There are 3 easy ways ...

Browsing All Comments By: Osman Goni Ridwan
  1. Reply
    Osman Goni Ridwan Aug 4, 2022 at 4:41 PM

    Hello Edward, to find out the total sales for one month, you can follow Criteria 7 of the following article.

    https://www.exceldemy.com/sum-index-match-multiple-criteria-in-excel/

    Here, the Criteria 7 shows how to determine the output based on all Rows & 1 Column with SUM, INDEX, and MATCH functions together. Let us know the result in the reply. Thank you!

  2. Reply
    Osman Goni Ridwan Aug 4, 2022 at 4:20 PM

    Hello SONYA, you can face this issue because of the following reasons:
    1. Incorrect Cell Ranges used in the formula
    2. The Date format used in the formula is not correct. You have to use a similar data format both in the cells and formulas.

    Check these things in your workbook and let us know the outcome. Thanks!

  3. Reply
    Osman Goni Ridwan Aug 4, 2022 at 3:11 PM

    Hello SHANMUGAM, can you please explain your problem a bit more elaborately? Then it will be easy to help you. Thanks!

  4. Reply
    Osman Goni Ridwan Aug 4, 2022 at 2:57 PM

    Hello Peter and Charlie, the solution described in this article at Criteria 2: “Extracting Data Based on 1 Row & 2 Columns with SUM, INDEX and MATCH Functions Together” is perfectly working from our end.
    Just to inform you, you can’t use a cell reference in the Look_up value of the MATCH function instead you have to insert the single of multiple look_up values manually e.g. {“Feb”,”Jun”}. Hope you have found your solution. Try it and let us know the outcome in a reply. Thank you!

  5. Reply
    Osman Goni Ridwan Aug 4, 2022 at 2:04 PM

    Hello, we are glad to hear that our article has helped you. After seeing your comment, I have extended the dataset to 260 rows and the formulas have worked perfectly from my end. Can you please recheck whether you have changed the formula text corresponding to your dataset? For example, in the dataset of 11 rows the formula for largest 5 values will be like =LARGE($C$5:$C$14,ROWS($G$7:$G7)) but when you extended the dataset till 260th row then the formula will be like =LARGE($C$5:$C$260,ROWS($G$7:$G7)).

    If you still face the problem then inform us in the reply. Thank you!

ExcelDemy
Logo