Share via

#REF Error on SUMIF function

Anonymous
2024-02-06T15:58:20+00:00

I am having an issue with the following SUMIF function =SUMIF(Summary!$C:$C,"P1*",Summary!$W:$W) I am trying to SUM column W on the summary sheet if column C starts with "P1", I am getting a #REF error when using that formula

Microsoft 365 and Office | Excel | For business | Windows

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. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-02-06T17:09:16+00:00

    Can you upload it to an online storage (eg Onedrive or Dropbox) and post a link here?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-02-06T17:03:40+00:00

    It is not returning #REF! errors anywhere, is there a way for me to attach the file so you are able to see what is happening?

    Was this answer helpful?

    0 comments
  3. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-02-06T16:43:35+00:00

    Only if that formula is returning #REF! errors somewhere.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-02-06T16:39:05+00:00

    No, there isn't a space before or after. I think the issue is that column C in the summary tab is actually a formula "=Mapping!$L$4" that returns the following potential values P1W1, P1W2, P1W3, P1W4, P2W1, P2W3, P2W4 etc... could that be an issue on why my sumif is not working? if so, how would I get around that

    Was this answer helpful?

    0 comments
  5. HansV 462.6K Reputation points
    2024-02-06T16:09:14+00:00

    Check whether the name of the Summary sheet has a space before of after the word Summary.

    If so, remove the space from the name.

    Was this answer helpful?

    0 comments