How to sum particular cells within the same column

[PP3321]

Sorry I cannot upload file but here is that the table looks like.

I need to sum every traffic in Column C.

My solution is to use SUMPRODUCT & MOD Function...

=SUMPRODUCT(--(MOD(ROW(C1:C12),4)=2),C1:C12)

My question is, is there any simpler way to achieve this?

Here are 3 conditions:

*I can not create a helper column...
*If possible, NO SUMPRODUCT...
*If possible, NO array formula...

 

[Hui]

I wish people would post files instead of pictures of files!

 

[Hui]

=SUMPRODUCT(IFERROR((C1:C21="Traffic")*(C2:C22),0)) Ctrl+Shift+Enter
or
=SUM(IFERROR((C1:C21="Traffic")*(C2:C22),0)) Ctrl+Shift+Enter

 

[chirayu]

I just used a helper column

 

[NARAYANK991]

Hi ,

Something like this :

=SUMIF(C1:C11,"traffic",C2:C12)

Narayan

 

[PP3321]

I wish people would post files instead of pictures of files!

Yes @Hui I apologize for that.
It is easier for you to 'cook' if all the ingredients are presented in your kitchen...When I get 1 month free-trial at home PC then I can start uploading it. As a company policy I can not upload excel files online...

 

[PP3321]

@Hui Thank you for elegant array formula!!!
@chirayu Thank you for helper column solution! I like it!
@NARAYANK991 Thank you! That is the simplest way to go...! I hit myself thinking hey why didn't I think like that...