Hi
I have the following which works just fine
=SUMPRODUCT(--(Table_owssvr[Migration Slot]>= (ActualMigrations!D$3-6)),--(Table_owssvr[Migration Slot]<= ActualMigrations!D$3),
--(Table_owssvr[Department]= $A6))
If I then add a condition ie
=SUMPRODUCT(--(Table_owssvr[Migration Slot]>= (ActualMigrations!D$3-6)),--(Table_owssvr[Migration Slot]<= ActualMigrations!D$3),
--(Table_owssvr[Department]= $A6), --(Table_owssvr[Is_Migrated]="TRUE"))
It returns nothing even though the Is_Migrated is TRUE
Pointers appreciated.
Regards
John Berman
Bookmarks