Reply to thread

Message: [QUOTE="Alcala, post: 3799600"] 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 [/QUOTE]