Display multiple texts from a column when condition A and B are met

Hi,

Please advise: I am trying to display multiple text values within a cell from Col A when conditions are met for Col B and Col C.

In other words, I would like to display the company names within the same cell whose approval was received within a given month.

Raw data: Col A: Company name; Col B: Approval Recieved; Col C: Date approved

Company Approval Date
Received? Approved
Spring Yes Oct 31
Summer Yes Sep 26
Autumn Yes Aug 20
Winter Yes Nov 27
Water Yes Sep 15
Earth Yes Sep 17
Metal Yes Aug 17
Air Yes Sep 30
Fire Yes Oct 07
Red Yes Jul 27
Blue Yes Jun 09
White Yes Oct 05
Black Yes Nov 05

Desired report:
I was able to figure out the formula for 'Monthly Total',
=SUMPRODUCT(--($C$2:$C$14 ="Yes"), --($D$2:$D$14 >= DATE(2010, 6, 1)), -- ($D$2:$D$14 <= DATE(2010, 6, 30)))

But couldn't figure out how to display the corresponding multiple values in C18:C23.

Monthly
Total Desired results in this exact format (multi lines within a cell)
June 1 Blue
July 1 Red
August 2 Autumn,
Metal
September 4 Summer
Water,
Earth,
Air
October 3 Spring,
Fire,
White
November 2 Black
Winter

Your time and help are very much appreciated.

Regards,
fichen

Hi Dave,

Thank you for your quick response. I might have posted the question on the wrong excel category. I am seeking help on a formula that would do:

IF 'approval recevied == yes' && 'approved date >= begining of the month' && 'approved date <= the last day of the month"

DISPLAY 'the corresponding company names' within the same cell (where there would be multiple companies meet the requirements above)

Thank you for your assistance.

Regards.
fichen