SUBTOTAL IF x cell contain x text

[harky]

i only know how to use sumif
=SUMIF(G6:G81,"Bank",M6:M81)

how to use this for subtotal? if i filter Col A based on project...

 

[Fluff]

With that layout try it like

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Project Name	PR #	Issued Date	Item Description	Remarks	Transcation No.	Ref	Credit			Debit			Subtotal
2								5	10	Amount In	5	10	Amount Out
3	Budget		44197	Balance b/f from Bank Account			Bank			7263.97				7263.97	1
4	Budget		44197	Balance b/f from Cash			Cash			1549.3				1549.3	1
5	Budget		44197	Balance b/f from $5 Voucher	Credit In		V5	11						11	1
6	Budget		44197	Balance b/f from $10 Voucher	Credit In		V10		1					1	1
7
8
9
10			Current Balance
11			Ref	Categories			Balance
12			Bank	Bank			7263.97
13			Cash	Petty Cash			1549.3
14			V5	5			11
15			V10	10			1
Data

Cell Formulas
Range	Formula
N3:N6	N3	=IF(G3="Bank",J3+M3,IF(G3="Cash",J3+M3,IF(G3="V5",H3+K3,IF(G3="V10",I3+L3))))
O3:O6	O3	=SUBTOTAL(103,A3)
G12	G12	=SUMIFS(N3:N6,G3:G6,"Bank",O3:O6,1)
G13	G13	=SUMIFS(N3:N6,G3:G6,"Cash",O3:O6,1)
G14	G14	=SUMIFS(N3:N6,G3:G6,"V5",O3:O6,1)
G15	G15	=SUMIFS(N3:N6,G3:G6,"V10",O3:O6,1)

 

[harky]

With that layout try it like

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Project Name	PR #	Issued Date	Item Description	Remarks	Transcation No.	Ref	Credit			Debit			Subtotal
2								5	10	Amount In	5	10	Amount Out
3	Budget		44197	Balance b/f from Bank Account			Bank			7263.97				7263.97	1
4	Budget		44197	Balance b/f from Cash			Cash			1549.3				1549.3	1
5	Budget		44197	Balance b/f from $5 Voucher	Credit In		V5	11						11	1
6	Budget		44197	Balance b/f from $10 Voucher	Credit In		V10		1					1	1
7
8
9
10			Current Balance
11			Ref	Categories			Balance
12			Bank	Bank			7263.97
13			Cash	Petty Cash			1549.3
14			V5	5			11
15			V10	10			1
Data

Cell Formulas
Range	Formula
N3:N6	N3	=IF(G3="Bank",J3+M3,IF(G3="Cash",J3+M3,IF(G3="V5",H3+K3,IF(G3="V10",I3+L3))))
O3:O6	O3	=SUBTOTAL(103,A3)
G12	G12	=SUMIFS(N3:N6,G3:G6,"Bank",O3:O6,1)
G13	G13	=SUMIFS(N3:N6,G3:G6,"Cash",O3:O6,1)
G14	G14	=SUMIFS(N3:N6,G3:G6,"V5",O3:O6,1)
G15	G15	=SUMIFS(N3:N6,G3:G6,"V10",O3:O6,1)

oh tht hard to understand
it work but =SUBTOTAL(103,A3) is a must?

 

[Fluff]

Yes it is, unless you want something even more complex.

 

[harky]

Yes it is, unless you want something even more complex.

thanks!.. had to hide tht column

 

[Fluff]

You're welcome & thanks for the feedback.