1. E

    Nested If question

    Hi, Can someone please help me with this? I have a table like this: Code --> Column A: ZSA, SAW, GEN, PT1,SSS, AAA,... Phase---> Column B: Phase 1, Phase 0, Phase 1, Phase 2,Phase 0, Phase 1,.... Task-->Column C: 05-11, 05-4, 05-78,05-8,05-13,05-20...... I would like to create a new column...
  2. D

    Excluding specific criteria

    I have a countifs statement that is counting all data in one column, but I need to add to the statement that excludes any data in column L that has Expired in the cell.
  3. K

    Sumproduct that excludes Wildcard data

    I'm trying to write a Sumproduct formula that will exclude some data using a wildcard. Specifically, I want to sum Column C where Column A=”OEM A” but does not include “BB” and Column B = Labor or Material. Here'w what I tried that is not working... =SUMPRODUCT(--(LEFT($A$1:$A$12,5)="OEM...

Some videos you may like

This Week's Hot Topics