I know the basics on excel formulas. I am trying to add a range of formulas based on criteria on one of the columns.

If x cell's value is RCNC then count the next 12 cells on the same row as RCNC = subtotal

Then I need to add all the subtotals of multiple rows to give me a Grand total.

Hopefully somebody can help me with this formula that is too complicated for my basic knowledge of excel.

Thanks.