Maybe:

{=SUM(IF((Guide=B483)*(LEFT(Month, 3)="CAL"),Revenue))}