VBA ARRAY formula

[chunu]

Hi,
i want help in two things to amend the following formula.

I have to drag down every column to fill the formula, it should be filled automatically till the last empty row of column A.
second thing , range (FUNDS!$a$2:$a$50)&FUNDS!$b$2:$b$50,FUNDS!$c$2:$c$50) should be dynamic.

With Sheets("MONTHLY").Range("b3:m3")       
.FormulaArray = "=SUM(IF(COLUMNS($B2:B$2)&$A3=MONTH(FUNDS!$a$2:$a$50)&FUNDS!$b$2:$b$50,FUNDS!$c$2:$c$50,0))"   
 End With

Note:-This formula or any other approach to get same result.

Thanks

SADWAL wfo.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	NAME	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
3	Abdul wahab	0	0	0	0	0	0	0	0	0	0	0	0
4	Afzal gondal	0	0	0	0	0	2000	0	0	0	0	0	0
5	Awais kahoot	0	0	0	0	1000	0	0	0	0	0	0	0
6	Awais Qamar	0	0	0	0	2000	0	0	0	0	0	0	0
7	Chaudhary Assad ur rehman	0	0	0	0	5000	1000	0	0	0	0	0	0
8	chaudhary Fazal numberdar	0	0	0	0	0	2000	0	0	0	0	0	0
9	Chaudhary Ghulam hussain	0	0	0	0	0	5000	0	0	0	0	0	0
10	Chaudhary Kashif mustafa	0	0	0	0	5000	0	0	0	0	0	0	0
11	Chaudhary maqsoom	0	0	0	0	0	1000	0	0	0	0	0	0
12	Chaudhary Mukhtar hussain	0	0	0	0	0	500	0	0	0	0	0	0
13	Dilnawaz kahoot	0	0	0	0	2000	0	0	0	0	0	0	0
14	Ghufam abbas kahoot	0	0	0	0	1000	0	0	0	0	0	0	0
15	Haji Ibrar kahoot	0	0	0	0	0	5000	0	0	0	0	0	0
16	Iqbal farash	0	0	0	0	0	2000	0	0	0	0	0	0
17	Javed farash	0	0	0	0	0	1000	0	0	0	0	0	0
18	Kamran kahoot	0	0	0	0	0	500	0	0	0	0	0	0
19	Khizar sb	0	0	0	0	0	1000	0	0	0	0	0	0
20	Malik ali abbas	0	0	0	0	1000	0	0	0	0	0	0	0
21	Malik Fazal ur rehman	0	0	0	0	0	1000	0	0	0	0	0	0
22	Maqbool bakhwal	0	0	0	0	0	2000	0	0	0	0	0	0
23	Master Ghukam hussain	0	0	0	0	0	5000	0	0	0	0	0	0
24	Master Noor muhammad	0	0	0	0	0	1000	0	0	0	0	0	0
25	Muhammad Ejaz kahoot	0	0	0	0	0	10000	0	0	0	0	0	0
26	Muhammad Fiaz kahoot	0	0	0	0	0	10000	0	0	0	0	0	0
27	Muhammad sajjad kahoot	0	0	0	0	1000	5000	0	0	0	0	0	0
28	Nazim Abul rasheed	0	0	0	0	0	10000	0	0	0	0	0	0
29	Previously collected	0	0	0	0	16200	0	0	0	0	0	0	0
30	Pro Shafiq ur rehman	0	0	0	0	0	2000	0	0	0	0	0	0
31	Qaiser sb	0	0	0	0	0	1000	0	0	0	0	0	0
32	Raja Shabir	0	0	0	0	0	10000	0	0	0	0	0	0
33	Shoaib Ejaz kahoot	0	0	0	0	5000	0	0	0	0	0	0	0
34	Umair kahoot	0	0	0	0	0	1000	0	0	0	0	0	0
35	Zulfiqar kahoot	0	0	0	0	0	1000	0	0	0	0	0	0
36	kuka	0	1000	0	0	0
MONTHLY

Cell Formulas
Range	Formula
A3:A36	A3	=FACEBOOK!R:R
B3:M3	B3	=SUM(IF(COLUMNS($B2:B$2)&$A3=MONTH(FUNDS!$A$2:$A$50)&FUNDS!$B$2:$B$50,FUNDS!$C$2:$C$50,0))
B36:F36,B4:M35	B4	=SUM(IF(COLUMNS($B$2:B3)&$A4=MONTH(FUNDS!$A$2:$A$50)&FUNDS!$B$2:$B$50,FUNDS!$C$2:$C$50,0))
Press CTRL+SHIFT+ENTER to enter array formulas.