=SUMPRODUCT((A1:A100="Buyer")*(C1:C100="January"), D1:D100)


"djcampanelli" wrote:

That worked awesome. Thank you. Now how would I do the same thing only add
up the dollar volume in column d.

"Teethless mama" wrote:

Assuming January is a text value

=SUMPRODUCT((A1:A100="Buyer")*(C1:C100="January"))


"djcampanelli" wrote:

I have a detailed worksheet that lists each buyer and seller that close on a
home. Column A = Buyer or Seller, Column C = Closing Month. I am creating a
totals area on my spreadsheet and for each month trying to determine how many
buyers and how many sellers. Lets say I want totals for January. I want to
look in column C find all of the January Records, then look in column a to
determine how many records were buyers. Then in a seperate cell I will do
the same for sellers. How can I do this? Any help is greatly appreciated.