Conditionally sum multiple values

[Jedi Master]

Good Day Everyone. This is probably a simple answer, but my brain is exhausted, so I am turning to you all for some guidance. I have a master worksheet that looks like the below:

The formula in cell O30 is:
=IF(A30="","",SUMIF('Change Order Worksheet'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet'!O30:O39)+SUMIF('Change Order Worksheet (2)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (2)'!O30:O39)+SUMIF('Change Order Worksheet (3)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (3)'!O30:O39)+SUMIF('Change Order Worksheet (4)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (4)'!O30:O39)+SUMIF('Change Order Worksheet (5)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (5)'!O30:O39)+SUMIF('Change Order Worksheet (6)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (6)'!O30:O39)+SUMIF('Change Order Worksheet (7)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (7)'!O30:O39)+SUMIF('Change Order Worksheet (8)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (8)'!O30:O39)+SUMIF('Change Order Worksheet (9)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (9)'!O30:O39)+SUMIF('Change Order Worksheet (10)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (10)'!O30:O39))

Each of the 10 change order worksheets has a Yes/No value in cell P13:

In the formula above, how do I include only the values from the individual 10 worksheets if the value of P13 is Yes?

 

[Fluff]

How about

=IF(A30="","",if('Change Order Worksheet'!P13="yes",SUMIF('Change Order Worksheet'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet'!O30:O39),0)+if('Change Order Worksheet (2)'!P13="yes",SUMIF('Change Order Worksheet (2)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (2)'!O30:O39),0)+...

 

[Jedi Master]

How about

=IF(A30="","",if('Change Order Worksheet'!P13="yes",SUMIF('Change Order Worksheet'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet'!O30:O39),0)+if('Change Order Worksheet (2)'!P13="yes",SUMIF('Change Order Worksheet (2)'!B30:B39,'Change Order Master'!B30,'Change Order Worksheet (2)'!O30:O39),0)+...

Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Jedi Master]

Fluff, I dont want to break any rules or do things the wrong way, so that is the context when I ask, can I post another question having to do with this in this thread? I know youve helped me quite a bit with this and you understand it pretty well which is why I am asking to do it this way, as the question I need to post is related to this thread, or should I make a new thread with my related question?

 

[Fluff]

Probably best to start a new thread.