M Michael Singmin Nov 13, 2003 #1 Hello Group, Can Sumproduct test the same range for "a" or "b" ? Thanks, Michael Singmin
C Chip Pearson Nov 13, 2003 #2 Michael, I'm not entirely sure what you're after, but perhaps the OR function will be useful. E.g., =OR(A1="A",A1="B") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Michael, I'm not entirely sure what you're after, but perhaps the OR function will be useful. E.g., =OR(A1="A",A1="B") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
D Don Guillett Nov 13, 2003 #3 Try this idea. Need NOT be array entered. =-SUMPRODUCT((ChecksC={"a","b","c","d"})*(ChecksD))
M Michael Singmin Nov 13, 2003 #4 Thank you Don, Sumproduct must be one the greatest functions of Excel. Your solution is perfect. Chip: My application is a Lims system for a water analysis laboratory. Samples can have an "a" or "b"' code which implies they are still incomplete. Thanks, Michael =================================================
Thank you Don, Sumproduct must be one the greatest functions of Excel. Your solution is perfect. Chip: My application is a Lims system for a water analysis laboratory. Samples can have an "a" or "b"' code which implies they are still incomplete. Thanks, Michael =================================================
