| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The Count Function
Can someone please tell me if the following is poosible;
Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
Hi,
Try this =SUMPRODUCT((A1:A20=C1)*(B1:B20=D1)) Withthe date your looking for in C1 and the fruit in D1 Mike "Yamorna" wrote: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
If C2 contains Apple and D2 contains 01/03/09 then
=SUMPRODUCT(--($B$2:$B$7=$C$2),--($A$2:$A$7=$D$2)) Regards, Stefi €˛Yamorna€¯ ezt Ć*rta: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
Use PIVOT table.
If this post helps click Yes --------------- Jacob Skaria "Yamorna" wrote: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
Formula would be the below if you have the lookup date and fruit in C1 and D1
=SUMPRODUCT(--(A1:A10=C1),--(B1:B10=D1)) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Use PIVOT table. If this post helps click Yes --------------- Jacob Skaria "Yamorna" wrote: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
Thanks a lot. I can't believe how simple that was.
-- Yamorna "Jacob Skaria" wrote: Use PIVOT table. If this post helps click Yes --------------- Jacob Skaria "Yamorna" wrote: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The Count Function
Hi! I know want to add up the total of the fruit column in another cell. By
using the Sum Function it is giving me a 'value' error? Suggestions? "Yamorna" wrote: Thanks a lot. I can't believe how simple that was. -- Yamorna "Jacob Skaria" wrote: Use PIVOT table. If this post helps click Yes --------------- Jacob Skaria "Yamorna" wrote: Can someone please tell me if the following is poosible; Date Fruit Consumed 01/03/09 Apple 01/03/09 Banana 01/03/09 Pear 02/03/09 Apple 03/03/09 Banana 03/03/09 Pear I need a function that can tell me how many apples were consumed on 01/03/09, how many bananas on 01/03/09 and how many pears on 01/03/09. The same for 02/03/09 and 03/03/09. Hope someone can help. Yamorna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count function | Excel Worksheet Functions | |||
| count function further | Excel Worksheet Functions | |||
| Another which count function? | Excel Worksheet Functions | |||
| WHICH COUNT FUNCTION? | Excel Worksheet Functions | |||
| using the count function | Excel Discussion (Misc queries) | |||
Linear Mode
