sumifs function is returning inconsistent results

Question

I have a workbook I use for tracking sales data annually. The first sheet is pure data while the second sheet is pulling data by month/ sales rep/ project type and a combination of, for analysis. I started this sheet about 4 years ago and usually make updates/ upgrades with every new year.

This year I simply took last years workbook, made a copy and cleared all the data on the first sheet, but now the "=sumifs" functions are returning inconsistent results. For example sales reps A, B, D, F will populate data on the analysis sheet as expected, but C and E do not populate and its the same with the project types.

I use a "sumifs" formula to fill the charts on the analysis sheet The " =sumifs " formulas have three conditions. The first two are ">=" and "<=" to search the months based on date of sale. The third is either the rep or the product type (2 different charts). The third condition is to select the sales rep or project type, and are both set as drop down lists on the data sheet tied to the charts on the analysis sheet to eliminate errors on data entry.

Does anyone have thoughts as to what is causing this to work sporadically?

Answer 1

Hi @Steve McGill

What are the formula results for sales reps C and E?

If conditions permit, it is recommended to share a simple example.

It is recommended to check whether the range of data reference in the formula is correct, such as the range of the third condition "criteria_range3".

---

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.

---