Hey guys,
I know this is a long shot, but anyone got an idea why the below results in circular reference. The results are correct but I would just like to get ride of the error![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
=SUMPRODUCT(--((INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$45,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))=$A46)),--(INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$44,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))>=$B$9),--(INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$44,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))<=$B$10))
B7 = 2
B8 = 600
B9 = 1st day of month
B10 = last day of month
B18 = A
B19 = RL
B20 = 2
E44 =246
E45 = 247
A46 = SiteName
Thanks anyone who can help, much appreciated....
I know this is a long shot, but anyone got an idea why the below results in circular reference. The results are correct but I would just like to get ride of the error
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
=SUMPRODUCT(--((INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$45,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))=$A46)),--(INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$44,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))>=$B$9),--(INDEX(INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$7&":$"&$B$19&"$"&$B$8),,MATCH(E$44,INDIRECT("HeadcountFeed!$"&$B$18&"$"&$B$20&":$"&$B$19&"$"&$B$20),0))<=$B$10))
B7 = 2
B8 = 600
B9 = 1st day of month
B10 = last day of month
B18 = A
B19 = RL
B20 = 2
E44 =246
E45 = 247
A46 = SiteName
Thanks anyone who can help, much appreciated....