All pastes #906604 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-16 20:37 UTC
rendered paste body
=SUM(
	IF(
		ISNUMBER(
			SEARCH("FULL",Sheet1!$C$4:$C$7498)
		),
		IF(
			ISNUMBER(
				SEARCH("2007",Sheet1!$D$4:$D$7498)
			),
			Sheet1!L$4:L$7498,0
		),
		AND(Sheet1!$M$4:$M$7498>5)
	)
)