Hello,
I have a spreadsheet in which is added data in 2 columns each month at the end of the sheet, called "NET" and "VAT". I am trying to write a formula that sums entries from last 12 columns "NET" (one formula for last 12 "NET" columns, f.e AK, AI, AG, AE etc) and "VAT" (another formula for last 12 "VAT" columns, f.e AL, AJ, AH, AF etc) (yearly review) no matter how many they are.
I am using for similar purpose (summing last 12 entries, but here is added just one column monthly) this formula:
but do not understand it well enough to rework it for my needs.
Any help is greatly appreciated.
I have a spreadsheet in which is added data in 2 columns each month at the end of the sheet, called "NET" and "VAT". I am trying to write a formula that sums entries from last 12 columns "NET" (one formula for last 12 "NET" columns, f.e AK, AI, AG, AE etc) and "VAT" (another formula for last 12 "VAT" columns, f.e AL, AJ, AH, AF etc) (yearly review) no matter how many they are.
I am using for similar purpose (summing last 12 entries, but here is added just one column monthly) this formula:
Code:
=ROUND(SUM(INDEX(I15:ZT15,MATCH(9^9,I$12:ZT$12)-11):ZT15),2)
but do not understand it well enough to rework it for my needs.
Any help is greatly appreciated.