Another question about Arrays and Wildcards

[Echooo3]

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?

[JBeaucaire]

Maybe:

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

[Echooo3]

That worked. You are a genius! Thank you so much.

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.