Hello Team,

I have these three columns in my excel. I need to find how many claims are pending with Status Code 17 for each month.

A B C
Initial Work Date Amount Status Code
01/13/17 $128.00 17
02/01/17 $59.00 17
01/18/17 $128.00 01
01/18/17 $59.00 17
02/20/17 $59.00 17
03/01/17 $59.00 17
01/18/17 $59.00 01
03/05/17 $59.00 17
01/18/17 $672.00 17

If Column A2:A10 is equal to or before 01/31/17, then what is the amount which is pending.(17 Status Code)
If Column A2: A10 is after 01/31/17 but is equal to or before 02/28/17, then what is the amount which is pending (17 Status Code)
and the same way If Column A2: A10 is after 02/28/17 but equal to or before 03/31/17, then what is the amount which is pending (17 Status Code)

Please help with your suggestions.

Regards
Abhi.