Assumed that I have a four columns as follow:
a1 b1 c1 d1

6a 3a 7a

All I want is to count the total of cell:a1,b1,c1 and place the total number in d1 cells. I put the formula =SUMIF(a1:c1,"*a",a1:c1) in the cell d1, but it don't work.
Now I'm really need you help to solve above problem.
Please help me.
many thanks.