Subtotal formula from a different sheet

[Tocix]

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

B	M
John	840
Cindy	400

Sheet2

Name	completed
John	415
John	100
John	325
Cindy	400

 

[Fluff]

You need to use sumifs like

=Sumifs(Sheet2!B2:B900,Sheet2!A2:A900, B2)

 

[Tocix]

OMG!!! Thank you very much, kind sir. You save me tons of time

 

[Fluff]

You're welcome & thanks for the feedback.