Nested Function & Offset Cells Help

Good afternoon,

I need assistance with the attached files. Basically, I have the following formula that counts the cells fine, except now I need to count every other cell:

=IF(COUNTIF(C4:C11,">0"),COUNTIF(C4:C11,">0"),"-")

Additionally, I have a nested Sum function that I need to also sum every other cell. Currently, I am using:

=IF(SUM(C4:C11),SUM(C4:C11),"-").

Thanks a bunch for your assistance. DeannaTest Events.xlsx

hi

c12> =SUMPRODUCT(($B$4:$B$11<>"Time:")*C4:C11)
c13> =SUMPRODUCT(($B$4:$B$11="Time:")*C4:C11)

It worked great! You are awesome. Thanks a bunch for your help.