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.

Combos Paid
Combos Bonus
Tops	Paid	100
	Bonus	50
Combos	Paid	200
	Bonus	100

<tbody>
</tbody>

 

[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.