![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 47%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For education | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 56.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Dear @Dominic Ngugi,
Thank you for posting your question in the Microsoft Q&A forum.
As a moderator, I don't have the tools to investigate your specific account directly. Because this is a user-to-user support forum so I have the same experience as you and other users in this forum. Moderators, contributors including external Microsoft employees cannot directly intervene in Microsoft product features or access back-end systems. Our role is limited to providing technical guidance on reported issues, requests, or ideas. However, I will try my best to guide you as clearly as possible.
To help me assist you better, could you please help me answer a few questions below:
Could you please attach an image or your file so I can get a more accurate and comprehensive overview?
Alternatively, if possible, copy the specific section where the SUMIF is returning 0 into a new file and send it to me via private message. That would make it much easier for me to identify the problem.
Note: To access private message, at the top of your post will appear a notification, please help me click on 'View message'.
There are several potential causes for this issue, such as 'Numbers stored as text,' 'Mismatched criteria' (hidden spaces), etc.
So, please attach an image or provide the file so that everyone in the forum can see it and offer the most appropriate advice.
I am looking forward to your response so we can move forward with this!