Need to count if due within two weeks AND status equals two specific values in another col

[alb2p]

I have a due date column and a status column. Status column can be one of five values.

Need to count if record is within two weeks of due date AND status field is NOT "In Review" or "Complete".

Should I use Countif or Sumif - and how can I do this with the multiple criteria?

Thanks.

[icestationzbra]

neither may suit this need since COUNTIF and SUMIF do not allow for any manipulation in the RANGE argument, SUMPRODUCT might work better.

it could be structured as:

=sumproduct(((due_date-today's_date)<=14)*((status<>"in review")+(status<>"complete")))

[FDibbins]

or, take a look at using countifS(), it allows for more criteria to be specified