Need help with a recapitulation formula

R

riott51

New member
Joined
Oct 29, 2012
Messages
3
Reaction score
0
Points
0
I need help with an IF formula for recapitulating a spreadsheet as seen below:

ABCD
1O710
2O611
3O610
4O534
5Total65
6
7Recapitulation
8O710
9O621
10O534
11Total65
 
In cell B8 use:

Code: 
=SUMIF($A$1:$A$4,$A6,B$1:B$4)

Copy/Autofill down and across to cell C10.
 
You must log in or register to reply here.
Back
Top