Hi All,
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="class: grid, width: 0"]
<colgroup><col style="width: 99px"><col width="75"></colgroup><tbody>[TR]
[TD="align: right"] $ 1,059.92 [/TD]
[TD="align: center"]Type A[/TD]
[/TR]
[TR]
[TD="align: right"] $ 3,100.00 [/TD]
[TD="align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: right"]$ 22,969.95 [/TD]
[TD="align: center"]Type C[/TD]
[/TR]
[TR]
[TD="align: right"]$ 2,173.00 [/TD]
[TD="align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: right"] $ 100.00 [/TD]
[TD="align: center"]Type C[/TD]
[/TR]
</tbody>[/TABLE]
If i wanted to find the sum of say of type C accounts what would be the correct formula?
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="class: grid, width: 0"]
<colgroup><col style="width: 99px"><col width="75"></colgroup><tbody>[TR]
[TD="align: right"] $ 1,059.92 [/TD]
[TD="align: center"]Type A[/TD]
[/TR]
[TR]
[TD="align: right"] $ 3,100.00 [/TD]
[TD="align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: right"]$ 22,969.95 [/TD]
[TD="align: center"]Type C[/TD]
[/TR]
[TR]
[TD="align: right"]$ 2,173.00 [/TD]
[TD="align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: right"] $ 100.00 [/TD]
[TD="align: center"]Type C[/TD]
[/TR]
</tbody>[/TABLE]
If i wanted to find the sum of say of type C accounts what would be the correct formula?