Share via

My SUMIF formula returning Zero

Anonymous
2023-06-23T23:30:51+00:00

I'm trying to use SUMIF to Sum data from Column N only when the corresponding Data in Column K meet the conditional formatting rule.
Please help.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-24T07:15:02+00:00

    Hello Ashish,

    Thank you for your reply,

    It still didn't work for me.

    I should mention that the data in N column come from a formula of multiplication.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-06-24T06:12:36+00:00

    =SUM((COUNTIF(C2:C25,K2:K20)>0)*(N2:N20))

    Was this answer helpful?

    0 comments
  3. Ashish Mathur 102K Reputation points Volunteer Moderator
    2023-06-23T23:59:15+00:00

    Hi,

    This works on a Windows machine

    =SUM(NOT(ISERROR(XLOOKUP(K2:K6,C2:C11,C2:C11)))*(N2:N6))

    Hope this helps.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-06-23T23:33:58+00:00

    Here is the formula for the conditional highlighting.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2023-06-23T23:33:15+00:00

    The cell selected is where I inserted the formula as shown but it always returns Zero

    Was this answer helpful?

    0 comments