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
|