Countifs and Sumifs of the past 30, 60, 90 days

Hello All,

I would like to know if anyone would help solve the issue that I am having.

I downloaded the table attached and I need to get the countif and sumif of the following criteria:

Count
IF Status - CS
IF Closed Date: Any sales of the last 30 days (03/01/2015 minus 30 days)

Sum:
Sum of SP$
IF Status - CS
IF Closed Date: Any sales of the last 30 days (03/01/2015 minus 30 days)

Basically I would to know the count of sales of the last 30 days and the total amount of this past 30 days sales.

Can anyone can help me with this?

Thanks,

Alysson Vallini

Count and Sum.xlsx

FYI:
Column B is Status
Column F is SP$ (Selling Price)
Column I is Closed Date