Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Trying to count the number of buyers or sellers for a given month.
34 views
Skip to first unread message
djcampanelli
Sep 17, 2009, 6:35:01 PM9/17/09
to
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.
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.
Teethless mama
Sep 17, 2009, 6:44:01 PM9/17/09
to
Assuming January is a text value
=SUMPRODUCT((A1:A100="Buyer")*(C1:C100="January"))
Ashish Mathur
Sep 17, 2009, 7:10:54 PM9/17/09
to
Hi,
You may also create a pivot table. Drag column A to the row area. Drag
column C to the row area or column area (as you wish) and drag column A
(again) to the data area.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"djcampanelli" <djcamp...@discussions.microsoft.com> wrote in message
news:081B8B9A-54ED-476D...@microsoft.com...
djcampanelli
Sep 17, 2009, 7:34:05 PM9/17/09
to
That worked awesome. Thank you. Now how would I do the same thing only add
up the dollar volume in column d.
up the dollar volume in column d.
Teethless mama
Sep 17, 2009, 9:00:14 PM9/17/09
to
=SUMPRODUCT((A1:A100="Buyer")*(C1:C100="January"),D1:D100)
0 new messages