my sumproduct formula with multiple criteria works well except that it is ignoring new data in the table. New data is inserted at the top of the table & all other lines shift down - range remains the same.
I have checked format - whole table is 'number' - the table range is correct ($P$7:$KI$2000) with new data inside that range - NB: if I resort the table data with new lines shifted to within the middle of the data table sumproduct still ignores those entries ( cells P7 P8 P9). There are no error messages. Criteria includes; (pest type row 1 rats possums etc) (trapping line number col.B 1n,2n,3n etc) (Date To & Date From col.C)
Any help would be appreciated.
I have checked format - whole table is 'number' - the table range is correct ($P$7:$KI$2000) with new data inside that range - NB: if I resort the table data with new lines shifted to within the middle of the data table sumproduct still ignores those entries ( cells P7 P8 P9). There are no error messages. Criteria includes; (pest type row 1 rats possums etc) (trapping line number col.B 1n,2n,3n etc) (Date To & Date From col.C)
Any help would be appreciated.