Complicated SUMIFS

pywhacket

Board Regular
Joined
Mar 24, 2006
Messages
84
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"
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,958
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top