Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count the number of buyers or sellers for a given month.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count the number of buyers or sellers for a given month.
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count the number of buyers or sellers for a given month.
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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count the number of buyers or sellers for a given mo
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count the number of buyers or sellers for a given mo
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the Number of Weekdays by Month | Excel Discussion (Misc queries) | |||
Count number of row for Particular month | Excel Worksheet Functions | |||
Count, number of entries of a particular month. | Excel Worksheet Functions | |||
Count number of items by month | Excel Worksheet Functions | |||
Count number of days in given month? | Excel Worksheet Functions |