Data
<TBODY>
</TBODY><COLGROUP><COL span=6></COLGROUP>
New worksheet
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
What I want is, when I populate the date, the totals for 2000,3000 etc should give me the total for the account for the date. I need a formula
10/01/12</SPAN> | 2000</SPAN> | 3000</SPAN> | 4000</SPAN> | 5000</SPAN> | 6000</SPAN> |
1A</SPAN> | 1.00 </SPAN> | ||||
2A</SPAN> | 2.00 </SPAN> | ||||
3A</SPAN> | 3.00 </SPAN> | ||||
4A</SPAN> | 4.00 </SPAN> | ||||
5A</SPAN> | 5.00 </SPAN> | ||||
Totals</SPAN> | 1.00 </SPAN></SPAN> | 2.00 </SPAN></SPAN> | 3.00 </SPAN></SPAN> | 4.00 </SPAN></SPAN> | 5.00 </SPAN> |
10/01/12</SPAN> | 2000</SPAN> | 3000</SPAN> | 4000</SPAN> | 5000</SPAN> | 6000</SPAN> |
1A</SPAN> | |||||
2A</SPAN> | 2.00 </SPAN> | ||||
3A</SPAN> | |||||
4A</SPAN> | 4.00 </SPAN> | ||||
5A</SPAN> | 5.00 </SPAN> | ||||
6A</SPAN> | 6.00 </SPAN> | ||||
Totals</SPAN> | 6.00 </SPAN></SPAN> | 2.00 </SPAN></SPAN> | - </SPAN></SPAN> | 4.00 </SPAN></SPAN> | 5.00 </SPAN> |
10/01/12</SPAN> | 2000</SPAN> | 3000</SPAN> | 4000</SPAN> | 5000</SPAN> | 6000</SPAN> |
1A</SPAN> | 1.00 </SPAN> | ||||
2A</SPAN> | 2.00 </SPAN> | ||||
3A</SPAN> | - </SPAN> | ||||
4A</SPAN> | - </SPAN> | ||||
5A</SPAN> | - </SPAN> | ||||
6A</SPAN> | 6.00 </SPAN> | ||||
7A</SPAN> | 7.00 </SPAN> | ||||
Totals</SPAN> | 1.00 </SPAN></SPAN> | 2.00 </SPAN></SPAN> | 7.00 </SPAN></SPAN> | - </SPAN></SPAN> | 6.00 </SPAN> |
10/01/12</SPAN> | 2000</SPAN> | 3000</SPAN> | 4000</SPAN> | 5000</SPAN> | 6000</SPAN> |
1A</SPAN> | 1.00 </SPAN> | ||||
2A</SPAN> | - </SPAN> | 2.00 </SPAN> | |||
3A</SPAN> | - </SPAN> | ||||
4A</SPAN> | - </SPAN> | 4.00 </SPAN> | |||
Totals</SPAN> | 1.00 </SPAN></SPAN> | - </SPAN></SPAN> | - </SPAN></SPAN> | 2.00 </SPAN></SPAN> | 4.00 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=6></COLGROUP>
New worksheet
Date</SPAN> | 10/01/12</SPAN> |
2000</SPAN> | 1.00 </SPAN> |
3000</SPAN> | 2.00 </SPAN> |
4000</SPAN> | 3.00 </SPAN> |
5000</SPAN> | 4.00 </SPAN> |
6000</SPAN> | 5.00 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
What I want is, when I populate the date, the totals for 2000,3000 etc should give me the total for the account for the date. I need a formula