Sheet Summary Help - IF Status and Date greater than

Prime George

Good morning,

I am trying to displat a Metrix on a Dash. I am using a sheet summary. Is it possible to write a formula that would show only items entered in 2021? The sheet goes back to 2016.

IF Status = Complete And Date greater than 12/31/2021

Currently the formula is: =COUNTIF(Status:Status, "Complete") but this shows over 4000+ orders.

Thank you in Advance.

lilywramirez

Hi @Prime George - Yes Date:Date would be your date column.

=COUNTIFS(Status:Status, "Complete", [PO Received Date]:[PO Received Date], ISDATE(@cell), [PO Received Date]:[PO Received Date], YEAR(@cell)>2020)

Prime George

That did it. Thank you so much!!!!!

lilywramirez

Hi @Prime George - COUNTIFS will allow you to have multiple criterion.

=COUNTIFS(Status:Status, "Complete", Date:Date, ISDATE(@cell), Date:Date, YEAR(@cell)>2020)

Prime George

Hi lilywramirez,

Thank you for the response. Is "Date:Date" my column name? If so should it be something like:

=COUNTIFS(Status:Status, "Complete",[PO Received Date:PO Received Date], ISDATE(@cell), Date:Date, YEAR(@cell)>2020)

lilywramirez

Hi @Prime George - Yes Date:Date would be your date column.

=COUNTIFS(Status:Status, "Complete", [PO Received Date]:[PO Received Date], ISDATE(@cell), [PO Received Date]:[PO Received Date], YEAR(@cell)>2020)

Prime George

That did it. Thank you so much!!!!!