Hi,

In summary tab in cell a1, I need to write a forumla that looks up in sheet 1,

"Countif B2:B1680 is "SC" and E2:1680 is "Yes"

any help would be great thanks