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