Hello there
I am having issues with my filters, the results are pulled through SUMIF formulas which work. So it pulls the data and categories this into the relevant months.
=SUMIFS('Jun''20'!$U$2:$U$730,'Jun''20'!$Q$2:$Q$730,">="&'Grouped Data'!U22,'Jun''20'!$Q$2:$Q$730,"<="&'Grouped Data'!V22)
So in example-the problem relates in Feb 20 as it is showing an extra 50 units and Dec 20 which is also showing an extra 50 units.
I can see when the data has been filtered down (values taken from subtotals) , that excel displays another piece of data at the bottom which does not match the filtered criteria, this is in fact the extra 50 units for Feb. So by hiding this, it corrects it. However I am unable to work out why Dec 20 has extra units. No data is hidden in the table.
Please can you help, it would be much appreciated.
I am having issues with my filters, the results are pulled through SUMIF formulas which work. So it pulls the data and categories this into the relevant months.
=SUMIFS('Jun''20'!$U$2:$U$730,'Jun''20'!$Q$2:$Q$730,">="&'Grouped Data'!U22,'Jun''20'!$Q$2:$Q$730,"<="&'Grouped Data'!V22)
So in example-the problem relates in Feb 20 as it is showing an extra 50 units and Dec 20 which is also showing an extra 50 units.
I can see when the data has been filtered down (values taken from subtotals) , that excel displays another piece of data at the bottom which does not match the filtered criteria, this is in fact the extra 50 units for Feb. So by hiding this, it corrects it. However I am unable to work out why Dec 20 has extra units. No data is hidden in the table.
Please can you help, it would be much appreciated.
