Reapplying/Editing funtion

[vishwajeet_chakravorty]

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 109px"><COL style="WIDTH: 71px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="BACKGROUND-COLOR: #008080">Allawance</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">100</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">232</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="BACKGROUND-COLOR: #008080">Examtion for tax</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffcc00">1600</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B11</TD><TD>=MIN(COUNT(B3:B10)*200)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

There is a problem in the result of the funtion that it is taking 200 from all the cells including B3 but in B3 the the number is 100. I want that the cells wherever the numbers are less than 200 the funtion should add that number itself not 200. According to me the result should be 1500. Kindly provide me the solution by reapplying any other funtion or by editing the same funtion.

 

[Andrew Poulsom]

One way:

=SUMIF(B3:B10,"<200")+(COUNTIF(B3:B10,">=200")*200)