Hi,
I have a huge table of data that I need to extract some detail out of using multiple conditions.
The column conditions are in B6:B33 where I need it to equal A1 in Sheet1.
The 1st row condition is in C2:GJ2 where I need it to equal A2 in Sheet1.
The 2nd row condition is in C5:GJ5 where I need it to equal A3 ("IAQ") in Sheet1.
For example, this would be the SUM solution where the 2nd row condition is actually static as "Options".
=SUM(IF('SS18 Planned Options'!$B$6:$B$33=$A1,IF('SS18 Planned Options'!$C$5:$GJ$5="Options",IF('SS18 Planned Options'!$C$2:$GJ$2=A$2,'SS18 Planned Options'!$C$6:$GJ$33)),0))
Confirmed with CSE.
I would need to change "Options" to "IAQ" and make it find the average without factoring in 0's.
Thanks,
I have a huge table of data that I need to extract some detail out of using multiple conditions.
The column conditions are in B6:B33 where I need it to equal A1 in Sheet1.
The 1st row condition is in C2:GJ2 where I need it to equal A2 in Sheet1.
The 2nd row condition is in C5:GJ5 where I need it to equal A3 ("IAQ") in Sheet1.
For example, this would be the SUM solution where the 2nd row condition is actually static as "Options".
=SUM(IF('SS18 Planned Options'!$B$6:$B$33=$A1,IF('SS18 Planned Options'!$C$5:$GJ$5="Options",IF('SS18 Planned Options'!$C$2:$GJ$2=A$2,'SS18 Planned Options'!$C$6:$GJ$33)),0))
Confirmed with CSE.
I would need to change "Options" to "IAQ" and make it find the average without factoring in 0's.
Thanks,
