From: Rao Ratan Singh on
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
From: Pete_UK on
Put this in C1 (say):

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

Hope this helps.

Pete

On Apr 26, 8:50 am, Rao Ratan Singh
<RaoRatanSi...(a)discussions.microsoft.com> 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