I have a sumif formula that is working for years 2019, 2017, 2016. The same sumif formula is not working for year 2018 River.
When I check the data tab and apply the same formula filters I am getting the correct value: 1,295,142. The sumif formula is incorrectly calculating 1,245,874.
I've checked datatypes and tried using sumproduct, yet I'm getting the same incorrect value with sumproduct. Any ideas on why this is occurring?
When I check the data tab and apply the same formula filters I am getting the correct value: 1,295,142. The sumif formula is incorrectly calculating 1,245,874.
I've checked datatypes and tried using sumproduct, yet I'm getting the same incorrect value with sumproduct. Any ideas on why this is occurring?
Attachments

314.2 KB Views: 5