Count every second row

[CreativeRova]

Hi,

How can I modify this formula to Count every second row?

=SUMIF(D14:D104,"Combos",(H14:H104))

will also need to complete a second cell with a sum of the in between cells based on the same info in column D.

So below is an example. in C1 I need to sum the Paid amounts when A = Combos. in C2 I need to sum the bonus amount when A = Combos.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Combos Paid[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Combos Bonus[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tops[/TD]
[TD]Paid[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bonus[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Combos[/TD]
[TD]Paid[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Bonus[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

why not just =countif(B:B,"paid")
change to Bonus if needed. You could use the same method for sumif()

 

[CreativeRova]

Hi FDibbins,

Wouldn't that count the occurrences of the word in B. I am after the sum of C if the word in A is correct. I should also state the spreadsheet will be repeated for a couple of thousand rows. each with paid and bonus and a few different things in column A. that's why it needs to search A then B to sum C.

 

[FDibbins]

Your question was...

How can I modify this formula to Count every second row?

Was that not what you wanted?

 

[CreativeRova]

It is, but still needs to meet the other parameters.