change the column I to D and sum the totals.

I am new, so i would try to explain my problem as best as possible.

I have a column "i" and i have done a =COUNTIF(SKU!I12:I184,">3") what i would like to do know is sum the rows that i have selected in the countif formula but from column d.

So i want to replicate the rows in the countif, change the column I to D and sum the totals.

I hope it could be done and i bet its easy, once you know how.

Hi, thanks

Ok that will give me the figure on this occasion, but what if the pivot table references 200 rows not 184 for example.

I want the sumif formula cells to match the countif cells automatically, like a reference.

No, i need the formula to pick up the same rows as the countif formula all the time automatically

Thanks i will try that out.