Hey All,
I am looking for a way to insert a function into this formula that will look at the first two letters in ('NCE NCW CDP Forecast'!D:D) part of the formula. The formula itself is correct, but it isn't pulling all of the information because some information in row D:D has more then 2 letters and this formula has to point to 2 letters only to work with the other sheets. E8 in this formula is what D:D is looking for hence, the reason to only see first 2 letters
Thanks for any help you can give.
=SUMIFS('NCE NCW CDP Forecast'!W:W,'NCE NCW CDP Forecast'!C:C,E7,'NCE NCW CDP Forecast'!D:D,E8,'kW Room'!I:I,"kw")/1000
I am looking for a way to insert a function into this formula that will look at the first two letters in ('NCE NCW CDP Forecast'!D:D) part of the formula. The formula itself is correct, but it isn't pulling all of the information because some information in row D:D has more then 2 letters and this formula has to point to 2 letters only to work with the other sheets. E8 in this formula is what D:D is looking for hence, the reason to only see first 2 letters
Thanks for any help you can give.
=SUMIFS('NCE NCW CDP Forecast'!W:W,'NCE NCW CDP Forecast'!C:C,E7,'NCE NCW CDP Forecast'!D:D,E8,'kW Room'!I:I,"kw")/1000