#### queenjauvier

##### New Member

- Joined
- Jan 2, 2018

- Messages
- 3

=SUM(COUNTIFS(Q23:Q5022,">595",R23:R5022,">3", S23:S5022, "<55"),COUNTIFS(Q23:Q5022,">595",R23:R5022,">3",S23:S5022,">55"))

And here's the function with some nested arithmetic:

=SUM(COUNTIFS(Q23:Q5022,">"&AC17+(AC18*AL25),R23:R5022,">"&AD17+(AD18*AL25),S23:S5022,"<"&AE17+(AE18*AL25)),COUNTIFS(Q23:Q5022,">"&AC17+(AC18*AL25),R23:R5022,">"&AD17+(AD18*AL25),S23:S5022,">"&AE17+(AE18*AL25)))

For reference: AC17 + (AC18*AL25) = 602.4 + (14.3492*(-0.55)) = 594.507

AD17 + (AD18*AL25) = 4.8 + (2.7203*(-0.55)) = 3.304

AE17 + (AE18*AL25) = 59 + (7.4027*(-0.55)) = 54.929

What should happen is that the two functions should compute the same value since they have the exact same criteria, ranges, and conditional operators. However, the value that I get from the first function is 3401, whereas the value outputted by the second function is 3464. Is this caused by an issue of rounding in excel? Am I forgetting some important syntax component in the second function?

Thanks for the help