Relative And Fixed Adressing

[ZOHAR]

Respected,
I was able to make a workable template but that is not functioning properly when I copy it completely or part of it for new data calculation. mostly that is the case with fixed addressing.
So please go through the sheet..
HAPPY EASTER

THANKX FOR ALL THE PREVIOUS HELPS AND IN ADVANCE FOR THIS
Zohar
Please cc to zoharsb@gmail.com

[olasa]

The solution to your problem is to use the OFFSET function.
When the Year and Quarter change the offset will reference a new block of data.
I.e.
Cell 1: Year*40+Quarter*10 --> 0*40+1*10 =Row 10
Cell 2: Year*40+Quarter*10+1 --> 0*40+1*10+1=Row 11
...

Hope it helps
//Ola

[ZOHAR]

Respected Sir,
I am unable to understand how can I use it with a long if,s which has encased DATEDIF, and's and or's.

Zohar