SUMIF incorrect result issue

[fanboy]

Hello everyone,

I have a sumif formula - SUMIF(A:A,"Diesel fuel",C:C) running in a spreadsheet with just under 1000 rows of data which is returning an incorrect result.

I've gone through the following processes to try to work out what is wrong

• All names corresponding to "Diesel fuel" have been confirmed to be correct
• All values have been confirmed as numbers and not text
• Superfluous tabs have been removed from the same workbook to confirm these are not interfering with calculation
• Superfluous columns have been removed from the same worksheet to confirm these are not interfering with the calculation
• I've deleted much of the dataset to confirm that the area of calculation is not the problem

I have managed to identify some of the cells that are not being summed that should be, but I can find no connection between them. I can't think of what else could be wrong here.

Does anyone have any advice that they could give on what could be causing the issue?

Thank you so much for your help,

 

[RoryA]

If values in column C are being ignored then either they are text, or the corresponding values in column A are not actually "Diesel Fuel". Or you have a circular reference or manual calculation. I think that pretty much covers the most likely options.

 

[fanboy]

Figured it out. Some of the "Diesel fuel" entries were actually "Diesel fuel " entries (a space was entered after fuel).

The filter I was using wasn't differentiating, but the formulas were.

Sorry to waste people's time here, and thanks for the help, Rory