To group and total values in excel:
Formula not allowed.=SUMIF(A2:A10,"A2", B2:B10).
Excel rejects with message: problem with the formula
Tried to include " in front of = as per excel advise.
" =SUMIF(A2:A10,"A2", B2:B10)
Also tried:
=SUMIF($A$2:$A$10,"A2", B2:B10)
Solved by T. H. in 27 mins