I"m trying to make a table that calculated partial pressure.

In the attachment go to the Partial Pressure tab.
The first table calculates based on the atmospheres you put in.

What I want is to be able to put the depth in the A8 of the second table and have it do the same calculations of the first table.
I'm not sure if a SUMIFS function is the appropriate way to approach this... probably not since it's not working.

I tried doing this
=SUMIFS(A8,"<=32",B8*1,"<=65",B8*2,"<=98",B8*3)
but it won't work.
I'm not sure if it's a conflict in the use of the "less than or equal to" statements, since if something is less than or equal to 98, then everything below it would also fall within that range.

I wasn't sure how to set a range like
SUMIFS(A8,"0-32",B8*1,"33-65",B8*2,"66-98",B8*3)
where if the number in A8 is a number between 0 and 32, then multiply B8 x 1.

I tried this
=IF(AND(A8>0,A8<34),B8*1) OR(AND(A8>33,A8<66),B8*2)

I'm almost definitely notusing the proper syntax to make these work if I'm even on the right track.

Attached Files

MOD Tables.xlsx (21.4 KB, 7 views)

Maybe like shown in the attached.

Attached Files

MOD Tables_2.xlsx (27.3 KB, 8 views)

Suh-weet.

I wasn't even close...