Sum adjacent columns based on criteria

Good morning all,

I'm new to the forum and a novice when it comes to VBA.

I'm currently tasked with calculating the thickness of material [anything containing RBL (rubble)] in a samples, however the calculation should terminate when the first SST or CNG (sandstone or conglomerate) is encountered. The forumula will the have to loop down the worksheet. An example is attached as a jpeg.

I have ten of thousands of rows to calculate.

Any advice or assistance will be greatly appreciated.
Thanks,
Andy

Hi,

Cause you attach a picture and we don't know location of cells in need...
Use SUMIF..

Hi Tom,

Thanks for your reply. Rather silly of me to attached a picture. Please find attached a xmls example.

I will give SUMIF a go.

Cheers,

In H13 use:

=SUMIF(G2:G11,"RBL",H2:H11) for Unit_3 and m3