The __ character is change cell 1A_B__C_D___________________E --> Columns 2__A__B 3__10_1_A____________________A 4__20_2_>20__________________>20 5__30_3_>20__________________CONCATENATE(">2","0") 6__40_4 7__50_5_20___________________0 8__60_6_DSUM(B2:C8,"B",D3:D4)__DSUM(B2:C8,"B",E3:E4)
-- DSUM() does not recognise concatenated values for search criteria in OO 3.2 (does in 3.1 and windows OO 3.2) https://bugs.launchpad.net/bugs/587209 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs