Share via

Excel Countif and sum functions not working

Anonymous
2019-11-06T18:32:52+00:00

I have a spreadsheet of reservations for a room. It lists who is responsible for that reservation.  At the top, I have a summary where it will count each name and give a total (ie - "=countif I:I,A2" where "A2" is the persons name).  This works fine.  I then try to sum this column of numbers. The function arguments box while I build it gives the "formula result= 37" but when I hit OK, the cell says "0" and I can't run my other formula based on that total.  What is going on???? How do I fix it????

Microsoft 365 and Office | Excel | For home | 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. Anonymous
    2019-11-07T02:57:43+00:00

    =countif I:I,A2

    0 comments
  2. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2019-11-07T03:05:04+00:00

    Hi,

    I think there is a circular reference on the file.  Share the link from where I can download the file.

    0 comments
  3. Anonymous
    2019-11-07T03:14:03+00:00

    I'm sorry, there is personal data in the file so I can't share it.  Please explain what might be the circular reference.

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more