Put this in C1 (say):

=SUMIF(A:A,"Total",B:B)

Hope this helps.

Pete

On Apr 26, 8:50*am, Rao Ratan Singh
wrote:
Hi All,
I have a List in which in a B Colum i want to sum if it have "Total" in A
Column

what should i do