Method to find discrepancy in sumif function

[mingali]

Hi,

I have attached a worksheet with a simple example. Row 2-10 are the source.

Row 15-21 use cost centre code to look for figures while Row 24-30 use cost centre name instead. Both use sum if function.

In this example, we can see the total for all three are agreed. However, in my actual worksheet with rows over 3000+ does not tally with the same concept.

Is there a method that can be used to let me find the discrepency by identifying exactly which source row create the difference in those two results?

Hopefully someone is willing to help.


Thanks

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.