this is really beating me up so if someone could help me out that would be awesome.
I am using this formula:
SUMPRODUCT(INDIRECT("'BBO Count'!B"&MATCH($A4,'BBO Count'!$B:$B,0)&":J"&MATCH($A4,'BBO Count'!$B:$B,0)),--(MONTH('BBO Count'!$B$3:$J$3)=MONTH(B$3)))
I have added columns to my sheet and when I change the string (highlighted red) it then returns a "Value Error". anyone have any idea why?