Good morning All,
I'm seeking for a subtotal formula that uses sheet 2's cell data. For instance, the subtotal will appear on M2 if cell B2 matches cell data on sheet 2. I've tried =COUNTIF(Sheet2!A2:A900, B2) it only gave me total of 3 rather than 840. I hope that makes sense. Thanks for checking.
Sheet1
Sheet2
I'm seeking for a subtotal formula that uses sheet 2's cell data. For instance, the subtotal will appear on M2 if cell B2 matches cell data on sheet 2. I've tried =COUNTIF(Sheet2!A2:A900, B2) it only gave me total of 3 rather than 840. I hope that makes sense. Thanks for checking.
Sheet1
B | M | |
John | 840 | |
Cindy | 400 | |
Sheet2
Name | completed | |
John | 415 | |
John | 100 | |
John | 325 | |
Cindy | 400 |