Hello and thank you in advance for your assistance.

I have a spreadsheet as follows:

Column C= Revenue
Column D= Units
Column E = Months, as a number (i.e. 1-12)
Column F = Status, expressed as either Prospect or Definite
Column G = Year (i.e. 2009)

Column A,B are labels and not used in the calculations.

I want to sum the units and revenue based on year, month, and status (i.e.,
how many units sold in January of 2009 that are in Prospect status). The
result for unit and revenue are in two other columns, K & L (i.e. there is a
summary cell for unit based on month, year and status, and another for
revenue based on month, year, and status)

The formula I am using is:
=SUMPRODUCT(--(G1:G500="2009"),--(F1:F500="Prospect"),--(E1:E500="1"),D1:D500) for units, and

=SUMPRODUCT(--(G1:G500="2009"),--(F1:F500="Prospect"),--(E1:E500="1"),C1:C500) for revenue

Excel returns 0, which I know is incorrect. I have tried removing the
quotes from the year and the month, but still get 0. I have checked the cell
format for the result cell and it is set to number format.

Thanks again for your thoughts.

Best regards,

Alberto