0320WorkBook1.rar
--------------------------
INDEXOFARRAY(b4:b15,INARRAY(CONCATENATE(MONTH(MONTHDELTA(TODAY(),-1)),"月底实际"),a4:a15))-
INDEXOFARRAY(b4:b15,INARRAY(CONCATENATE(MONTH(MONTHDELTA(TODAY(),-2)),"月底实际"),a4:a15))
C列的
INDEXOFARRAY(c4:c15,INARRAY(CONCATENATE(MONTH(MONTHDELTA(TODAY(),-1)),"月底实际"),a4:a15))-
INDEXOFARRAY(c4:c15,INARRAY(CONCATENATE(MONTH(MONTHDELTA(TODAY(),-2)),"月底实际"),a4:a15))
较比年初增减
INDEXOFARRAY(b4:b15,INARRAY(CONCATENATE(MONTH(MONTHDELTA(TODAY(),-1)),"月底实际"),a4:a15))-b2