Need help with IF formula

riott51

New member
Joined
Oct 29, 2012
Messages
3
Reaction score
0
Points
0
I need help with creating a formula to recapitulate values on a spreadsheet as shown in the sample below. Thanks for your assistance.
Rich

ABC
O710
O611
O610
O534
Total65
Recapitulation
O710
O621
O535
 
You could use the SUMIF formula =SUMIF(range,criteria,sum_range).
Assuming your range is A1:C4 then =SUMIF(A1:A4,"O7",B1:B4) would give you 1 and =SUMIF(A1:A4,"O7",C1:C4) would give you 0
where A1:A4 is the range of O7,O6,O6.....
"O7" is the criteria or the criteria could be a cell containing the value O7
and B1:B4 is the range of the values you want to sum
 
Back
Top