Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count New to the List, Count Leaving the List, Count Total
Ok, this is a variation of a previous question
Column D is a list of data at the beginning of the month. Column C is the list of data at the end of the month. What formulas do I need in cells B1, B2, B3 and B4 to get the answers I provided in Column B below? No helper columns. Thanks very much for taking a look. Column A Column B Column C Column D Beginning of month 5 apples apples New to the list 5 pears grapefruits Leaving the list 3 bananas beans End of month 7 green green blue red yellow brown |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count New to the List, Count Leaving the List, Count Total
I think this works:
cell B1 =COUNTIF($D$1:$D$2000,"*") Cell B2 =COUNTIF($C$1:$C$2000,"*")-SUMPRODUCT(--(ISNUMBER(MATCH(C1:C2000,D1:D2000,0)))) Cell B3 =-(COUNTIF($D$1:$D$2000,"*")-SUMPRODUCT(--(ISNUMBER(MATCH(C1:C2000,D1:D2000,0))))) Cell B4 =-(COUNTIF($D$1:$D$2000,"*")-SUMPRODUCT(--(ISNUMBER(MATCH(C1:C2000,D1:D2000,0))))) "SteveC" wrote: Ok, this is a variation of a previous question Column D is a list of data at the beginning of the month. Column C is the list of data at the end of the month. What formulas do I need in cells B1, B2, B3 and B4 to get the answers I provided in Column B below? No helper columns. Thanks very much for taking a look. Column A Column B Column C Column D Beginning of month 5 apples apples New to the list 5 pears grapefruits Leaving the list 3 bananas beans End of month 7 green green blue red yellow brown |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count the dates for each criteria and list total occurances for ea | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count numbers in list | Excel Worksheet Functions | |||
count if ?? List if? | Excel Discussion (Misc queries) | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions |