Thursday 2 August 2012

Sum Function Working


Plus
Plus value Select values and Click the Sum Button =sum(12+12)

 Minus
Minus value =Sum(45-12) or =Sum(A1-A2)

Multipal
Multipal value =sum(45x12) or =sum(A1xA2)

Divide
Divide value =sum(45/12) or =sum(A1/A2)

Multipal Sum

=Sum(A1:A5) + sum(A7:A12)
=Sum(B2:B12) + Sum(C2:C12) + sum(D2:D12)
=sum(B2:B12) – sum(C2:C12)
=sum(B2:B12) x sum(C2:C12)
=sum(B2:B12) / sum(C2:C12)

=if(A1<>””,sum(B1:C1),”A1 cell is empty”)

No comments:

Post a Comment