Budget match to data channels

[mcoetzee]

Please can someone help?

I need to match my budget back to my Data with the numbers next to each channel in my expression.
	Data	Data	Excel Upload
Example:	PriorYear	CurrentYear	Budget
RECON	100	200	250
FirstSubScriberClassification	SubClassGroup (Upload from excel file)
DIRECT	RECON
FINDU	DIRECT
IIP	FINDU
LSS	GUARDING
RECON	RESIDENTIAL
RESIDENTIAL	SMALL COMMERCIAL
SMALL COMMERCIAL	IIP
Formula tried but not working
Sum(If(SwitchDesc = 'Clients' and Description = 'Sales' and SubClassGroup = FirstSubScriberClassification, Budget))

[Arthur_Fong]

Is it because of missing ''?

Sum(If(SwitchDesc = 'Clients' and Description = 'Sales' and SubClassGroup = 'FirstSubScriberClassification', Budget))

[mcoetzee]

FirstSubScriberClassification	Total	PY	CY	Budget
RESIDENTIAL	100	150	200	0

Does not seem to work

Budget return 0