ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum (https://www.excelbanter.com/excel-discussion-misc-queries/262400-sum.html)

Rao Ratan Singh

Sum

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

Sum

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

All times are GMT +1. The time now is 08:06 PM.