Sum

[Rao Ratan Singh]

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

 

[Pete_UK]

Put this in C1 (say):

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

Hope this helps.

Pete