- Jan 14, 2003
- Office Version
I am trying to do conditional sum. I have two tables both have ID numbers like E5G79296, E6G85377, etc. Table A may be missing some ID’s, so does table B, I want to sum the corresponding values in only if it the ID’ are same, I can not use SUMPRODUCT because one column has almost 5000 rows and another less that 2000. Can I use arrary SUM(IF formula if the tables are on two different sheets.?