This is what I have

{=SUM(IF((Guide=B483)*(Month="CALMAR"),Revenue))}

and it works. Just for your information; CALMAR is the calendar month of March.


But I want to change the array so it will sum for any month that starts with CAL. I thought I could use ="=CAL*" but it doesn't work. Any suggestions?