Data Collection that depends on various conditions

Hi,

I have a spreadsheet that is set up to collect data based on a source tab.

I am also introducing a new criteria into the source tab (Data Table 1) which will affect all the other tabs, the new criteria that I am introducing is "Process/General".

And based on the new criteria, all other formulas will change as well because the formulas (with 2 or 3 conditions) will now have this criteria included in them.

I just don't know how to incorporate this new criteria into the formulas.

For Example:

I have the following formula in the cell B16 of tab "B"

"=COUNTIF('Data Table 1'!$D$7:$D$271,A16)"

but now I have to introduce the criteria to count only if in tab "A" within column B (B7:B27) that meets the condition of "G"



Also,

in tab "B", I have the formula "=SUMIF(A!$D$7:$D$329,A16,A!$G$7:$G$329) and again I need to do what I mentioned above.

I tried it our myself but could not figure it out....can anyone please help, I've attached the document that I am referring to in the above.

Thanks for the help,

It worked.