All pastes #906626 Raw Edit

Untitled

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