sumproduct ignoring some data

Dorado99

New Member
Joined
Nov 12, 2020
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
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.
 

Attachments

  • BladeCurrentLiveScreen.png
    BladeCurrentLiveScreen.png
    236.8 KB · Views: 13
  • RepoortsKillScreen.png
    RepoortsKillScreen.png
    214.1 KB · Views: 12

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

ExcelGzh

Board Regular
Joined
Mar 29, 2020
Messages
130
Office Version
  1. 365
Platform
  1. Windows
Could you post the sumproduct formula that you are using?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,599
Messages
5,573,136
Members
412,506
Latest member
StaffanExcel
Top