Share via

HI I HAVE MICROSOFT 2021EXCEL 365 , I AMTRYING TO USE FILTER FUNCTION BUT IT GIVE ME THIS #CALC

ALAA2 0 Reputation points
2025-12-04T20:01:50.33+00:00

enter image description here

Microsoft 365 and Office | Excel | For business | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
    2025-12-04T20:23:46.97+00:00

    Hi @ALAA2,

    Thank you for posting your question in the Microsoft Q&A forum.

    Based on your screenshot, you want to extract the row in the data range G3:I16 that meet the condition: value in column H equal to cell K3 and value in column I equal to cell K6.

    Both your formula logic and syntax are correct and the error #CALC! that you are receiving means that there is no row in the data range meet your condition and Excel doesn't know what to return if nothing meets requirement. That's because the FILTER structure is =FILTER(array, include,[If empty]) and since you don't put anything in [If empty] part, Excel returns #CALC! error instead.

    Hope this information will help. Should you have any questions or need further assistance, feel free to reach out in the comments of this post. I'd be happy to assist you.    

    Looking forward to your response.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".          

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.