Formula test - HtmlMaker 20090730a.xla

[foverman]

HtmlMaker 20090730a.xla

Select A1:E17
Generate HTML | Specify options
User defined selection
Type E2

Sheet1

	A	B	C	D	E
1	Account	Description	Cost	Other	Subtotal
2	70600	401K B CONTRIBUTION	1281	1281	7060
3			1281		7060 Total
4	75100	ADVERTISING	7266	7266	7510
5	75101	ADVERTISING	-	-	7510
6			7266		7510 Total
7	70420	ATTENDANCE DAYS	-	-	7042
8			0		7042 Total
9	71100	AUTO & TRUCK	1724	1724	7110
10	71101	AUTO & TRUCK-MANUAL	-	-	7110
11			1724		7110 Total
12	70550	BONUSES	-	-	7055
13			0		7055 Total
14	75150	CO OP ADVERTISING	-	-	7515
15	75151	CO OP ADVERTISING-MAN	-	-	7515
16			0		7515 Total
17			10271		Grand Total

Excel 2003

Worksheet Formulas Cell Formula E2 =LEFT(A2,4) C3 =SUBTOTAL(9,C2:C2) E4 =LEFT(A4,4) E5 =LEFT(A5,4) C6 =SUBTOTAL(9,C4:C5) E7 =LEFT(A7,4) C8 =SUBTOTAL(9,C7:C7) E9 =LEFT(A9,4) E10 =LEFT(A10,4) C11 =SUBTOTAL(9,C9:C10) E12 =LEFT(A12,4) C13 =SUBTOTAL(9,C12:C12) E14 =LEFT(A14,4) E15 =LEFT(A15,4) C16 =SUBTOTAL(9,C14:C15) C17 =SUBTOTAL(9,C2:C15)