I have a sheet with 12,000 rows, I want to sum all the rows with a certain product ID, in the case below the product ID is LSCI30 so I use the formula =SUMIF([Item Code]:[Item Code], "LSCI30", Net:Net) and the result that is returned is $18,642.89. but if I then apply a filter to the
sheet using the same product ID and sum the column using the "sum" function I get a completely different result. I have tried using a different product code "LL" and the same thing happens. What obvious thing am I missing here?
