I am working on two tabs in a workbook to pull in data dependent on several conditions. I need help with the formula after this point:
=IF($C5="X",1,0)*SUMIFS(
I am working in cell J5 in tab NPS and I need to pull in a value in L from the Data tab if:
1) A5 NPS is found in column A of Data
2) If the value in column Z Data tab contains any of the following text "Notional 1, Notional 2, Notional 3"
3) If the value in column AB Data is "Com"
=IF($C5="X",1,0)*SUMIFS(
I am working in cell J5 in tab NPS and I need to pull in a value in L from the Data tab if:
1) A5 NPS is found in column A of Data
2) If the value in column Z Data tab contains any of the following text "Notional 1, Notional 2, Notional 3"
3) If the value in column AB Data is "Com"
