SUMIF Example

COMPANY	PROFIT		COMPANY	PROFIT
APPLE	500		APPLE	1000
MICROSOFT	400		MICROSOFT	1000
NOKIA	300		NOKIA	1000
SONY	200		SONY	1000
PIXEL	100		PIXEL	1000
			SUM IF	5000

Formula:-

=SUMIF(B2:B6,"<1500",E2:E6)