Formula to bring amounts from last month

[josros60]

Hi,
I have this formula the bring amounts from last month same workbook for previous sheet (tab) but sometimes works others not, help:

(sample sheet I am march sheet want to bring balances from February into February column)

=
FEBRUARY[@Feb]+SUMIFS(FEBRUARY[Feb],FEBRUARY[Account 
Number],[@[Account

Book9
	A	B	C	D	E
1	SAGE ID	Vendor Name	Account Number	Feb	Mar
2	BLACK	Black & McDonald Ltd.	938378	752.61	1,003.44
3	BROBRO	Brown Bros Motor	10351	472.17	1,893.07
4	CLOCTI	Cloud CTI	63015	USD 2,493.06.	USD 149.50.
5	100030	Connect Okanagan Telephone	100030	491.45
6	DATMAI	Datacore Mail Management Ltd.	DATMAI	0.00	641.81
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C6	Expression	=CELL("row")=ROW()	text	NO
A2:C6	Expression	=COLUMN()=CELL("col")	text	NO

Thank you,

 

[josros60]

Any help?

Thank you

 

[Peter_SSs]

Any help?

I think that you would have more chance of help if you:

• Gave us the actual formula you have. What you have posted is not a complete formula.
• Told us where that formula is
• Gave us a sample of the table from the previous sheet and explained what value(s) from that sheet should come into the March sheet shown

 

[josros60]

This is the complete formula that is in April sheet, bringing amount from previous month (March) for comparison:

=SUMIFS(MARCH[Mar],MARCH[Account 
Number],[@[Account 
Number]])

Thank you