I have used the following to get a grand total count:
=IF(COUNTIF('Sheet 1'!E2:E1344,"=0")-COUNTIF('Sheet
1'!E2:E1344,"30"),SUM('Sheet 1'!K:K),"")

I would now like to get a total for everything in column E matching the
above condition. How do I code that into my formula?