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

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

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

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

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

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

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