Sum values in column O until empty cell is reached whilst excluding "NO" values

[jfin1ty]

Hi all,

Hoping someone can help me with this query.
I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached.
I would like to expand upon this formula so that it still sums like I have mentioned above but will not include summing for any value in column "O" if the value on the same row in column AC is equal to NO. Is this possible?
I have made the start of the formula have some if, or, and, offset evaluations that are required for a plethora of reasons I'd rather not get into so really I'd imagine it would just be a tweak to the SUM formula part onwards?

Book1
	A	B	C	D	E		G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1															T
2				RG			11.559	SP000000				WP			2.705
3												WP			0.960
4												WP			1.945
5												WP			0.634
6												WP			0.480
7												WP			2.555
8								SP000001				BS			1.220
9												BS			1.060
10
11				RG			12.154	SP000002				WP			0.955
12												WP			0.556
13												WP			2.128
14												WP			5.720
15												WP			2.795
Sheet1

Cell Formulas
Range	Formula
G2:G15	G2	=IF(OR(H2<>"",D2<>""),IF(AND(O2<>"",OR(OFFSET(O2,-1,0)="",OFFSET(O2,-1,0)="T")),SUM(O2:INDEX(O2:$O$101,MATCH(TRUE,($O2:O$101=""),0))),""),"")

 

[Peter_SSs]

There is no value in cell G10 due to the neither of the offset criteria being fulfilled. If row 9 cell O9 is not blank or equal to "Tonnes (t)" then the blank value is returned to G10.

Can you give a couple of examples of sample data and expected results where rows with values in column H do get values entered in column G and any further explanation about that situation?

Also, when using XL2BB you can make your sample easier to read/navigate in the forum if you only select the relevant range and also hide irrelevant columns in that range before producing your mini sheet. For example, for the first mini sheet in post #6 you could hide columns E:F, I:K, M:N and P:AB since none of them have a bearing on the currently discussed calculation and then just select D3:AC27 to produce the mini sheet. (Columns A:C are also not relevant but can be avoided by starting the selection as indicated rather than needing to hide them)