aamirsq
Member
Hi,
i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working
H1 : is my selection month
Row B3:M3 is my date
Row B4:M4 is my data which is i am adding using above formula.
Thanks
i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working
=SUM(B4:INDEX(B4:M4,MATCH($H$1,$B$3:$M$3,0)))
H1 : is my selection month
Row B3:M3 is my date
Row B4:M4 is my data which is i am adding using above formula.
Thanks