Need to count if past given due date AND meets two values in another column

[alb2p]

I have a due date column and a status column. The status column can be one of 5 values.

I need to count the record if it is past due date AND status is "Not started" OR "In Progress"

Should I use CountIFs or SumIFs? Please help.

[benishiryo]

hi alb2p. assuming Due Date in A2:A10 & Status in C2:C10, try:
=SUM(COUNTIFS(A2:A10,">"&TODAY(),B2:B10,{"Not Started","In Progress"}))

if it doesn't help, attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[alb2p]

this works but had to reverse the ">" to less than. Thanks so much for your help.